[AccessD] FE to BE updating

John,

One append query goes to just one table...but...the main form feeds a linked 
table...and on save it uses the code:

docmd.GotoRecord , , acNewRec

...would that cause a problem...if multiple people were trying to goto a new 
record at the same time?

Thanks,

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 18:13:09 -0400
>
>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
>
>
>
>_______________________________________________
>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