can't save

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
ty said:
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?
Click to expand...

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.
 
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, will you ready my question "Best way to share" and respond. Sounds
like you may have my answer. Thanks!
 
The databse is split.

Joan Wild said:
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?
Click to expand...
 
ty said:
The databse is split.
Click to expand...

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.
 
Back
Top