Access 2000

[Guest]

We have a database that was created using Access 2000. Everyday we
have user errors. Can't go to specified record. Unable to log into the db.
Locked up. Tried to re-log in to the database and it still doesn't work.
Frozen and doesn't access records. Is this a problem that is caused by a
slow response from our server? Is there any limitations to the number of
people who access the db? How can we correct these errors?

 

[Guest]

Hi,
the limit in access is 255 cuncurent users.
One question: Do you have your application split into a frontend and backend?
If not then you HAVE TO do so. It is vital in a multi user environment to
split your application and implement a true multi user set up.
HTH
Good luck

 

[John Vinson]

We have a database that was created using Access 2000. Everyday we
have user errors. Can't go to specified record. Unable to log into the db.
Locked up. Tried to re-log in to the database and it still doesn't work.
Frozen and doesn't access records. Is this a problem that is caused by a
slow response from our server? Is there any limitations to the number of
people who access the db? How can we correct these errors?

Do all users have full Read, Write, Create and Delete privileges on
the folder containing the backend (and, of course, the local folder
containing their own copy of the frontend)?

Do you compact the backend regularly (for a busy system, daily)?

Does giving the user a new clean copy of the frontend help?

Check at http://www.granite.ab.ca/access/corruptmdbs.htm for advice on
database corruption; I believe Tony also has a Performance FAQ which
might have some helpful suggestions.

John W. Vinson[MVP]