Multi user in Access 2000

[omadamx]

I have a database Access 2000 file format, and stored in a shared folder so
several users can access it at the same time. Most of the time it works fine,
but sometimes it shows a message that prevents them to work with it. It says
that the database is locked by another user and it can't be open. The users
that are already in can work without problem, but it doesn't allow new users
to come in. I tried to secured the database following the procedure described
in "Frequently Asked Questions About Microsoft® Access Security for Microsoft
Access versions 2.0 through 2000, Version 2.41, By Mary Chipman, Andy Baron,
Chris Bell, Michael Kaplan, Paul Litwin, and Rudy Torrico" but the security
wizard fails securing the database and after three days of continuos
processing it doesn't show any progress. Database file size is less than 6 MB.

 

[Jeff Boyce]

If I take your description literally, you have a single .mdb file stored on
the network that has multiple users trying to simultaneously get at it. If
true, this is not an optimal design. Not only can they end up in contention
with each other (this may be what you are seeing), but this leaves the
database open to higher risk of corruption.

The preferred design is to have the data (i.e., tables) only on the server,
and have a "front-end" .mdb file (no data, only forms, queries, ...) on each
user's desktop, linked to the tables in the "back-end" on the network.

Or have I misunderstood?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[omadamx]

Yes, that is my case. I avoided the splitted database because in some querys
it takes to long to update the forms and users don't like it. I tried to use
splitted and replicated database, so every computer would have a local copy
of the back end in their computers and syncronized with the server but in
some computers the performance was even worse, I couldn't find why. I tested
replicated single file database -in othe words tables and front end- (I know
it's not the best solution) and I got a better performance but I got
corrupted file very often, specially when the front end desing is modified.