can't save

[Guest]

Some of my users are reporting an error "Couldn't save; currently locked by
user 'Admin' on machine HAL90075". What does this mean? As far as I'm
concernec there are no security restrictions on any user or group. How do I
fix it?

 

[Joan Wild]

Some of my users are reporting an error "Couldn't save; currently
locked by user 'Admin' on machine HAL90075". What does this mean?
As far as I'm concernec there are no security restrictions on any
user or group. How do I fix it?

Well actually there are. Access always uses security. You are using the
system.mdw workgroup file that ships with Access. It silently logs every
user on as 'Admin' which has full permissions on everything.

One possibility is that the user on machine HAL90075 exited the database in
an abnormal fashion (ctrl-alt-del; power button).

Get everyone out of the database and look for a file with the same name as
the mdb but with a ldb extension - delete the ldb file.

Also are you running a single mdb on the server that everyone is using? You
should split the database into frontend (all the objects except
tables)/backend (just the tables/relationships). Put the backend on the
server and give each user a copy of the frontend on their computer - it's
linked to the tables in the backend.

 

[Guest]

Thanks. But I did not see any file with ldb extension. Could there be
another reason?

 

[Joan Wild]

OK, then are you running a single mdb on the server that everyone is
accessing, or is the database split?

Do all users have read/write/modify/delete permissions on the folder where
the database is?

 

[Guest]

Joan, will you ready my question "Best way to share" and respond. Sounds
like you may have my answer. Thanks!

 

[Guest]

The databse is split.

OK, then are you running a single mdb on the server that everyone is
accessing, or is the database split?

Do all users have read/write/modify/delete permissions on the folder where
the database is?

 

[Joan Wild]

The databse is split.

That's good, but it sounds as though the frontend is on the server and
everyone is using it. You should give a copy of the frontend to each user
on their computer.