Unlock table

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Anyone know how I can unlock a table I created in MSAccess by the user
Admin? I am using WindowsXP.

Cheers
Pat
 
Het is zò dat Pat formuleerde :
Anyone know how I can unlock a table I created in MSAccess by the user
Admin? I am using WindowsXP.

Cheers
Pat
Click to expand...

Close database, delete <databasename>.LDB, re-open database

is that what you mean?
 
Pat drukte met precisie uit :
If I delete the databasename how then can I open it again?
Click to expand...

You delete the LDB file (the locks-file) not the MDB file...

But this sort of depends on the cause of your problem; the lock-file
_might_ have a left-over lock in it from a previos (not properly
terminated) session. You might not even have the file (Access deletes
it when every user is logged out).

It could also be a case where the current database user doesn't have
admin-rights in the database

You could try opening the DB with the SHIFT depressed, perhaps some
code opens the table and thus prevents you from accessing it...
 
You could try opening the DB with the SHIFT depressed, perhaps some
code opens the table and thus prevents you from accessing it...
Click to expand...
I have just discovered the problem and it relate to not having a dongle
attached to an LTP port. I had been getting the error regarding the Access
file when I tried to add it to a third party program.

Thank you anyway for helping out.
Cheers
Pat
 
Back
Top