Unlock table

[Pat]

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

Cheers
Pat

 

[Gijs Beukenoot]

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

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

is that what you mean?

 

[Pat]

If I delete the databasename how then can I open it again?

 

[Gijs Beukenoot]

Pat drukte met precisie uit :

If I delete the databasename how then can I open it again?

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

 

[Pat]

You could try opening the DB with the SHIFT depressed, perhaps some

code opens the table and thus prevents you from accessing it...

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