HOW TO SHARE A DB BETWEEN DIFFERENT USERS

[neilou]

Hello,

I'm trying to share a database (MS Access 2000) between two other users. I set up the database in the server (which is a PC) and I would like all the users to be able to change and save the changes from their own PC then the information will be saved in the server without any conflict.

The sharing options are already set up in manner that everybody can read it and change it but when I try to save, problems...

Please Help.
P.S.: I'm not an expert!!!

 

[Shingebis]

When sharing a database, you have to remember that when a user opens a record, it is locked so that someone else cannot modify it at the same time. Depending on how you have constructed the DB this may be part of the problem. I am somewhat confused by your statement, "but when I save..." Access saves each keystroke and then updates the record when the form is closed, unless you have written code to do this otherwise.