Reference & Codes

[mgp]

When creating an event procedure in A2K, I get
an "illegal procedure call or argument". Even if I leave
it empty.
------------------------------------
Private Sub ButAddCo_Click()

End Sub
------------------------------------
When trying to change the references in tools to reset
them, I get "Can't remove control or reference; in use"

HELP !!!!

What can I do to troubleshoot this problem?

 

[Allen Browne]

The database is partially corrupt.

Try a decompile:
Backup your file first.
Close Access.
Open a command prompt.
Enter something like this. (It's one line, and include the quotes):
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\My Documents\MyDatabase.mdb"

Then open the database and compact (Tools | Database Utilities | Compact).

If it still crashes when importing, take note of WHICH object it is trying
to import when it crashes. Import the other objects, and rebuild that one
(or those ones).