Don't know if this link helps you? http://www.dbforums.com/microsoft-access/927450-simultaneous-edits-table-access.html
-----Original message----- From: "Scott Raley -ITC" [email protected] Date: Fri, 16 Jan 2009 08:54:15 -0500 To: cf-community [email protected] Subject: RE: MS Access > I did that yesterday on the machine that has the db and got a read only > message but I don't know if I was on the same record. > > -----Original Message----- > From: Michael Grant [mailto:[email protected]] > Sent: Friday, January 16, 2009 8:52 AM > To: cf-community > Subject: RE: MS Access > > It's been a while, but I'm pretty sure more than one person can edit a table > at the same time. I think a problem only arises if they try to edit the same > row at the same time or do an insert simultaneously. > > Why not just make a copy of the db and test the theory? > > -----Original message----- > From: "Scott Raley -ITC" [email protected] > Date: Fri, 16 Jan 2009 08:44:10 -0500 > To: cf-community [email protected] > Subject: RE: MS Access > > > Yes I read this to but it doesn't say that 2 users can input data at the > > same time.. can then? The tables are locked differently? > > > > -----Original Message----- > > From: Bruce Sorge [mailto:[email protected]] > > Sent: Friday, January 16, 2009 7:19 AM > > To: cf-community > > Subject: Re: MS Access > > > > How about splitting the database into a 'front end' and a 'back end'. > > One database will contain the actual data, and the other 'front end' > > database will contain the forms/queries and such, and would have links to > > the actual data. That is all I can think of. > > > > Bruce > > > > > > ----- Original Message ----- > > From: "Scott Raley -ITC" <[email protected]> > > To: "cf-community" <[email protected]> > > Sent: Friday, January 16, 2009 2:54 PM > > Subject: MS Access > > > > > > > I've taken over fixing the forms and tables on an MS Access database > that > > > is > > > 6 yrs old. Its Access 2000. Isn't there a limit that only one user can > > > add/edit data even though its going through forms because the database > is > > > locked, everyone else gets read only? Or is there a way around this? > I've > > > googled and not seen a clear answer other then Access 2000 is made to > > > support up to 50 users or less. The client is looking for at least 2-3 > > > people to enter data at the same time. I've googled 2003 and 2007 and > > > can't > > > find anything about multiple entries (or at least nothing in clear > > > English). > > > I see the stuff that I should split and give users an mde and keep mdb > on > > > the server but it still doesn't explicitly say this allows multiple > people > > > to enter data at the same time. Anyone? > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:285110 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
