HELP, please!!!

[Elaine]

I'm a fairly new user of Access, so please forgive me. I was in the process
of making changes to tables, using the wizard to make an auto-form and
assigning a command button in my main form to open the form, when the entire
database became frozen, and despite shutting down and re-starting - it is
still frozen. I did back-up the entire database yesterday, so if I have lost
today's changes, I'm not all that concerned. Please help!

 

[Ken Snell \(MVP\)]

Go to the folder where the database is located. Delete the file that has the
..ldb extension and the same file name as the database. Now try to open the
database.

 

[Elaine]

Ken,

That didn't work, since the record locking version is still using the main
open database. I tried deleting them both, but it won't let me do it. I was
able to make a copy, and I found where I made the error on one of the
subforms, so I deleted the subform and the command button on the main form,
so now that one works, (I saved it to a different name) but I still can't
close, save, or delete the original. I wasn't able to find the .ldb
extension, it just names it "Microisft Access Record-Loclking Information"

Any other ideas?

 

[Ken Snell \(MVP\)]

Sounds as if you are using the "default" setting in Windows to "Hide
extensions for known file types". I personally hate that option and always
turn it off (Go to Windows Explorer, and select Tools | Folder Options |
View and find this option in the list) -- I like to see the file extensions.
In your case, you do not see the .ldb extension because of this option, so
the two file names appear to be exactly the same. The "RecordLocking" file
is the one you want to to delete. But you must close the .mdb file first
before you try to delete that .ldb file.