John Colby
jcolby at colbyconsulting.com
Wed Aug 27 14:57:18 CDT 2003
If you use memo fields heavily, they don't follow the rules for record locking, rather they still use the old "block" locking. This may be causing the problem. Two memo fields trying to save to the same "block" of the db. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte Sent: Wednesday, August 27, 2003 3:42 PM To: accessd at databaseadvisors.com Subject: [AccessD] FE to BE updating 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com