Question HELP! All but forms and queries are gone? (1 Viewer)

[CryLittleSister]

Hi

I got a message from someone in another office to say that she could not generate a report, so she restarted the database and got the following error: The form name "Index" is misspelled or refers to a form that doesn't exist

I can still use the database fine but when I opened a second instance of the database, I got the same message. I clicked OK and can see that all forms, reports, macros and modules have disappeared from the list.

Has anybody any idea how this could have occurred and how it could be fixed? I daren't close my instance of DB now as I don't think I'll get it back, seems weird that it's working so normally in one place though.

(Cross posted here: http://www.accessforums.net/showthread.php?t=70459&p=386866#post386866)

 

[NauticalGent]

I see Ajax has engaged which means you are in good hands...

 

[isladogs]

Being as yours is still open, suggest you do File ... Save As so you have a backup.

Then compile, compact, close.
Next decompile, recompile, compact.
If all of that works, you can redistribute your copy.

Failing that, create a new database and import all items from your backup into that. Then compile and compact again.
Make another backup.