Erwin Craps
Erwin.Craps at ithelps.be
Thu Aug 28 02:21:13 CDT 2003
I don't know if this is of any help, but there is or was an issue with adding records with autonumber. I had corrupted tables when adding records in to a table togheter with the autonumber field ID. It will use the ID from the source table to put into the destination autonumber field. I don't believe this issue is solved in an SP. Thats when you do a append * to * Create a query with all field except the autonumber field. Erwin -----Original Message----- From: Mark A Matte [mailto:markamatte at hotmail.com] Sent: Thursday, August 28, 2003 4:25 AM To: accessd at databaseadvisors.com Subject: RE: [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