> -----Original Message----- > From: Scott Raley -ITC [mailto:[email protected]] > Sent: Friday, January 16, 2009 6:55 AM > To: cf-community > 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'm not sure if there's any way around this... although I'm not an expert. One thing you definitely can do is use Access as a front-end to something a bit beefier. SQL Server Express is free and (especially considering you're using Access now) should be perfect. I've not done it for a while, but I remember it being insanely easy to do - the users see no changes. That said I wouldn't be so sure that Access doesn't provide some capability here... I just don't know what it is. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:285101 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
