Mark A Matte
markamatte at hotmail.com
Wed Aug 27 14:41:46 CDT 2003
Hello All, In A97 I have a FE and BE scenario. The FE is on each local machine and the BE is on a network drive. I use an APPEND query in the FE to add new records to the BE. The users are getting an error that the records are locked by another user. I believe this is happening when 2 users try to save at the same time(execute the APPEND) because they never edit records...its always a new record. Two questions: 1. Is this a correct assumption? 2. If correct...how can I prevent this? Thanks, Mark A. Matte _________________________________________________________________ Help protect your PC: Get a free online virus scan at McAfee.com. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com