Multiuser database - Access 2003.

[Julian]

Can more than one user work on a Access 2003 database at the same time. I
was trying to do that and Access was asking me whether I want to overwrite
the records the other user has entered or lose mine.
Julian.

 

[Douglas J. Steele]

Access is multi-user right out of the box.

Sounds as though you and the other user were trying to update the same
record(s).

 

[Joseph Meehan]

Can more than one user work on a Access 2003 database at the same
time. I was trying to do that and Access was asking me whether I want
to overwrite the records the other user has entered or lose mine.
Julian.

Sure can and that message you got was proof that it was working as
intended. It is trying to keep you from overwriting data that may have been
changed by another user who was editing the same data at the same time you
were. As I recall, it looks at a "page" of data which may be one record or
more than one record so it is possible you were both on the same record or
different records. Most of the time you would not have been on the same
"page" so you would not get that message.

Hint: If you are going to do this often, you should look at database
splitting (front end & back end) and record locking in the help files to
better understand what is going on and what kind of issues you may face.