[AccessD] FE to BE updating

John Colby jcolby at colbyconsulting.com
Wed Aug 27 17:13:09 CDT 2003


It seems unlikely, in fact probably impossible.  All activity has to go
through jet and Jet will know that the autonumber is being updated.

Are you sure that the append query is not trying to append data to more than
one table?

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 4:04 PM
To: accessd at databaseadvisors.com
Subject: RE: [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

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





More information about the AccessD mailing list