Mark A Matte
markamatte at hotmail.com
Thu Aug 28 09:03:39 CDT 2003
Erwin, I took that into consideration...I am not appending the autonumber. The more I look at it...I think it is either the append query locking or its the GOTO.NEXTRECORD , ,ac NEWREC ? Any ideas? Thanks, Mark >From: "Erwin Craps" <Erwin.Craps at ithelps.be> >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: Thu, 28 Aug 2003 09:21:13 +0200 > >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 >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Get MSN 8 and enjoy automatic e-mail virus protection. http://join.msn.com/?page=features/virus