richardb said:
Of course, I re-started the work station. There's plenty of memory and disk
space. I also tried the fix of decompiling the database posted by Bill Mosca
First thing, make a backup copy of your MDB.
Second, can you still open the Visual Basic Editor?
If *no*, send your MDB to me in a ZIP file. I *may* be able to fix
it in no time at all, and at no cost (but also with no guarantee!)
If yes (you still *can* open the VBA Editor), do the following steps:
Open the immediate window (Ctrl+G), and type
Application.SaveAsText acReport, "YourReport", "C:\YourReport.txt"
and press <Enter>.
Now delete "YourReport" from the current MDB, and close Access. Rename
"YourApp.mdb" to "YourApp_old.mdb".
Start Access without opening a MDB. Create an new blank MDB. Select
the menu "Tools/Options..", click on the "General" tab and *uncheck"
the option "Track name AutoCorrect info". Close the Options dialog
with Ok. Save the MDB under "YourApp.mdb" (it is called db1.mdb when
you created it).
On the menu, select "File/Get External Data/Import..." and select
"YourApp_old.mdb" as the file to import from. In the following dilaog
box, select all objects on all tabs. Also click the "Options>>" button
and check "Menus and Toolbars" and "Import/Export Specs" if you have
any of these in your application ("Menus and Toolbars" meaning the
menus and toolbars you have created yourself within your application,
not the standard menues and toolbars that are included in Access
anyway).
Run the import.
Open the VBA Editor, open the immediate window (Ctrl+G) and type
Application.LoadFromText acReport, "YourReport", "C:\YourReport.txt"
and press <Enter>
Maybe you need to add some application specific references in the
dialog box "Tools/References..." if you use any of these in your
application (if you never have used this dialog box before, just
ignore this step).
Now your application should be fixed. You can delete the
file "C:\YourReport.txt".
HTH
Matthias Kläy
