running several users from one location

  • Thread starter Thread starter Moiz
  • Start date Start date
M

Moiz

I need to make regular changes to the front end of an Access Database (A
2000) and to make sure all users are using the same version
I update it once a day on the main server.

The database is set in Shared Mode, however when the second user tries to
open it it gives an error that changes will not be saved.

1. can 2 or more users work on the same database or should each one have
a different copy of the database
2. can I get rid of the error?

Thanks

Moiz
 
I would suggest splitting it into a BE FE. Then have everyone copy the new
FE to their desktop each morning. This way they will not get that message.
 
It is always best for each user to have their own copy. There error you are
getting implies the users are working directly in the table, queries, etc.
and have access to design view - bad idea.

First, you should put some real front end on the database so the users see
everything through forms and reports.

Are you actually modifying your database on a daily basis? This is pretty
unusual unless you are in serious development. Is the database split?
 
Back
Top