New Computer wont Run Databeas

[Guest]

Hello,

I deleveloped a database that worked fine until my company gave me a new
computer. The database will open, but none of the buttons on the forms work.
Most of the time, I get no error messages, nothing happens. Sometimes I get
" Eror in loading DLL".
If I delete and recreate a button, it works fine. I have a lot of buttons.
Any ideas as to the cause and solution?
The database was written on Access 2000 and the new machine is running
Windows XP.

 

[Allen Browne]

The problem could be with permissions, libraries, the old binary, or a
corruption. Whatever the cause, try this sequence:

1. Make sure you are logged into Windows as a local computer administrator
(not limited user.)

2. Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

3. Compact the database:
Tools | Database Utilities | Compact

4. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

5. Compact again.

6. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

7. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

You may find that the database comes good after the first couple of steps,
but I encourage you to follow through the other steps anyway.