Can't open multiuser database

[Bruce D]

Good evening folks,

I am running into what is probably a serious newbie problem here, but I
can’t figure it out and I am hoping that someone can tell me what to do
before I go postal! (Meaning no offense if you are a USPS employee.)

Anyway, we’ve been running this database for about 6 users in Access 97 for
about 6 or 7 years now, and we’ve been very happy with it. But, it was
finally time to replace our old computers, so we decided we would get new
computers with Access 03 on them and convert the database. The conversion
seems to have happened just fine. HOWEVER – we can no longer use the
database as a multiuser database! Each person can get into the converted
database, but only one at a time. When a second person tries to get in, they
invariably get the message that “The database has been [placed in a state by
user ‘Admin’ on machine ‘xx’ that prevents it from being opened or locked.â€

I have tried placing the machines in the same workgroup, but that didn’t
help. I have made sure that all of the machines have the latest patches for
everything. They are running XP SP2 and MS Ofc 2003 Pro. And – I don’t know
if this is at all relevant – the new machines have some program on them that
is an MS SQL 2000 client.

Anyway, I’d surely appreciate some help getting all of my users into this
database simultaneously. Thanks in advance,

-Bruce D

 

[Joan Wild]

Anyway, we've been running this database for about 6 users in Access 97
for
about 6 or 7 years now, and we've been very happy with it. But, it was
finally time to replace our old computers, so we decided we would get new
computers with Access 03 on them and convert the database. The conversion
seems to have happened just fine. HOWEVER - we can no longer use the
database as a multiuser database! Each person can get into the converted
database, but only one at a time. When a second person tries to get in,
they
invariably get the message that "The database has been [placed in a state
by
user 'Admin' on machine 'xx' that prevents it from being opened or
locked."

Ensure that all users have read/write/create/delete permissions in Windows
on the folder where the mdb is.

You should split the database and put just the backend(tables/relationships)
on the server. Give each user a copy of the frontend (all other objects) on
their computer - each frontend will be linked to the tables in the backend.