Strange Error: OnLoad Automation Error!?!?

[DJKAOS]

I have a database, anyway it worked fine yesterday..today I added some more features to it and now it works 100% fine on my laptop that I created it on, but on the other 3 office computers I get the same error every time I try to load any form...

"The Expression OnLoad you entered as the event property setting produced the following error: Automation Error"
"*The expression May not result in the name of a macro, user definded function or event procedure"
"*there may have been an error evaluating the function, event, or macro."

Then when the form does finally load I get errors for everything...Errors for when I click a button, errors for when I change a combo box.

Anyone have any clue what is going on?

both my *.MDE files and the *.MDB files give the same errors, although the *.MDB seems to give the error but then works anyway...where as the MDE doesn't work at all.

 

[RickSpr]

It sounds as if you might have a corrupt compile. Decompile it by running Access from the Windows Start>Run dialog, using the following command line:
&quot;<path to msaccess.exe>&quot; /decompile &quot;<path to .mdb file>&quot;
Then recompile the database code and see if it works.

If you have trouble getting that to work, try opening your form's code and modify it trivially--type a space somwhere you already have a space, for example. Then recompile and save.

Your last statement is the hint. The .MDB works anyway, but the .MDE doesn't. The primary difference is that the .MDB has source code in it, so when the compiled code has an error Access can dynamically recompile it. With the .MDE file, the compiled code is all there is, so you're stuck with the error. Rick Sprague