multiple users

[April G.]

Hi again!

I have a .mdb appl. that I have created for a client. It works great for one person, but multiple users cannot use it at the same time. This client has several other .mdb's that allow multiple users, no problem. I can't find any difference in those .mdb's and mine, that would not allow multiple users in mine. Any suggestions? (I'm using Access 2000).

Thanks,
April

 

[Calvin]

You need to look into record locking and look up multiple users in this forum as well as in Access's help files. If your process is working with lots of data you may need to consider splitting the database into a front-end and back-end.

 

[April G.]

Calvin,

Thanks for the reply. I have checked everything I can think of under security, options, etc. and nothing is popping out. It is a huge appl. and I do have separate front and back ends already. Default Open Mode is "Shared", Default Record Locking is "No Locks" and Open Database Using Record Level Locking is checked. Any other ideas?

April

 

[Calvin]

You should change your Record Locking from "No Locks" to "Edited Record" in a shared environment. But more than changing the default mode, you will have to go back into every form and change it cuz, changing the default only works going forward.
Also have you distributed the front end to each client workstation, or are the users trying to open the same shared file over the network? Each workstations should have it's own copy of the front end.