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:285108 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
