Error when opening database (2003)

Topic

New Reply

Perhaps the logon form has become corrupt, or the table it’s bound to (if any).
Start by making a backup copy of the database.

Try this first:
– Open the database with Shift held down.
– Select Tools | Database Utilities | Compact and Repair Database.

If that doesn’t help:
– Create a blank new database.
– Import all objects from the problem database.
– If one ore more objects can’t be imported, they are the culprit(s). See if you can import them from an older non-corrupt backup copy.

If that doesn’t help either:
– If you can find the database object that causes the problem, try to delete it, then to re-create it from scratch.
– Or go back to an older non-corrupt backup copy.

Reply | Quote

Replies

Subject edited by HansV because “Help” wasn’t very helpful

I have a database which opens with a form for users to logon. I just tried loging in, and got the Microsoft error message, and the option to backup the database. If I go into the database using the shift key, then open the logon form, it’s ok. Can anyone advice me what the problem could be?

Reply | Quote

It might also be worth trying a decompile – this has helped me out more times than I care to remember :

http://www.trigeminal.com/usenet/usenet004.asp%5B/url%5D

Nick

Reply | Quote

I use a2k (9.0.6926) SP-3 Jet 4.0 SP-8 and decompile 4 different applications several times a month and have always had great results.

Have any Loungers had a bad experience with decompile?

Thanks, John

I use a bat file to zip a backup and run the decompile on original mdb:

DecompCl.bat
del CleckDc.zip
wzzip -a ClerkDc Clerk.mdb
“C:Program FilesMicrosoft Office2kOfficemsaccess.exe”
“F:Appsaccess2kClerk.mdb” /decompile

Reply | Quote

I decompile databases quite often; I have added Decompile (and Compact) to the right-click menu for .mdb files. Many of the sample databases I post in the Lounge have been decompiled, then compacted to reduce file size. I very rarely encounter problems with it – once or twice I found that event procedures had lost their connection to the control they belong to, that’s all.

Reply | Quote

Thanks for all your advice. I took Hans advice, and found an old working copy, and transferred tables/forms over one by one, trying to logon each time. Still no joy until I transferred the logon form. It must have got corrupted, because as soon as I transferred it, I could logon. Any thanks to everyone for their help and advice, and I would like to wish you all a very merry christmas, and a happy new year.

Reply | Quote

where can I get whatever it is that puts the decompile option in the reight-click menu?

Reply | Quote

You can create it as follows:
– Start Windows Explorer.
– Select Tools | Folder Options…
– Activate the File Types tab.
– Select MDB in the list of file types.
– Click Advanced…
– In the Edit File Type dialog, click New…
– Enter Decompile in the Action box.
– Enter “C:Program FilesMicrosoft OfficeOffice11MSACCESS.EXE” /Decompile “%1” in the Application used to perform action box
– In the above, use the appropriate folder. This is usually Office for Access 2000, Office 10 for Access 2002, Office11 for Access 2003 and Office12 for Access 2007.
– OK your way out.
– You should now have a Decompile option in the right-click menu for .mdb files.

Reply | Quote

I have never had to use the decompile option at home, only on client sites.
I have set this up at home now, could be very handy.
Thank you Hans

Reply | Quote

You can add Compact to the right-click menu the same way, using the following command in the “Application used to perform action” box

“C:Program FilesMicrosoft OfficeOffice11MSACCESS.EXE” “%1” /Compact

Again, replace Office11 with the appropriate folder for your version (see my previous reply).

Reply | Quote

Good to know, thanks Hans.

Reply | Quote