Using access with DB from a usb drive, and it went to sleep!

[frixtine]

I was using access with a DB from a usb drive (stick drive) and while I was
working, the stick went to sleep, and now I can't open my database. I can
open it in excel and access the tables, but I can't get to my forms or
anything. Any ideas of what I can do to restore or repair it? If I can't, I
can redo the work I did, but I HATE having to do that!!!!

 

[Nick Stansbury]

Try a few things:

1) Decompile - use the decompile switch can sometimes sort this problem
2) Create a new database and import your forms and modules in - sometimes
helps
3) Repair the db - also found this sometimes helps

Nick