[AccessD] FE to BE updating

Thanks John,

But no memo fields.  Could autonumber fields cause a problem in this 
situation?


Thank,

Mark


>From: "John Colby" <jcolby at colbyconsulting.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] FE to BE updating
>Date: Wed, 27 Aug 2003 15:57:18 -0400
>
>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
>
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
MSN 8: Get 6 months for $9.95/month http://join.msn.com/?page=dept/dialup

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com