 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / November 2004Unlock table
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 Close database, delete <databasename>.LDB, re-open database is that what you mean?  SignatureYour eyes are weary from staring at the CRT. You feel sleepy. Notice how restful it is to watch the cursor blink. Close your eyes. The opinions stated above are yours. When I snap my fingers, you cannot imagine why you ever felt otherwise. If I delete the databasename how then can I open it again? > Het is z? dat Pat formuleerde : > > Anyone know how I can unlock a table I created in MSAccess by the user [quoted text clipped - 6 lines] > > is that what you mean? 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... SignatureYour eyes are weary from staring at the CRT. You feel sleepy. Notice how restful it is to watch the cursor blink. Close your eyes. The opinions stated above are yours. When I snap my fingers, you cannot imagine why you ever felt otherwise. > 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 > Pat drukte met precisie uit : > > If I delete the databasename how then can I open it again? [quoted text clipped - 11 lines] > You could try opening the DB with the SHIFT depressed, perhaps some > code opens the table and thus prevents you from accessing it... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.