Automation Error

[Earth]

Hi,<br><br>I've been updating a db for my work system: I've added little bits of code and forms to the previously working db, and now it won't start with the message &quot;Compile Error: Automation Error&quot; coming up, highlighting variable declarions/procedures in my main utilities module as points of error. The declarations that problems are found with usually involve the variable type &quot;Form&quot; or &quot;Control&quot;.<br><br>I'm completely stuck as to what has gone wrong, can anyone give me an idea of what direction to look in? The Access help files on the matter didn't help me greatly.<br><br>Thanks muchly.

 

[JimHorton]

You'll want to check the 'References' and/or 'Activex' section (depending on access version) in the 'Tools' menu item first, for 'Missing&quot; error msg; or make sure any custom controls on your forms are referenced there..&nbsp;&nbsp;Also, check the Delcarations in the modules for Declare statements that reference non-existent Dlls or Dlls that were moved.&nbsp;&nbsp;I saw this error on occasion in Access '95, if that's your version, I highly recommend you go to Access '97, NOT Access 2000, which is as buggy or more so (an this is a great feat) than Access '95.<br>--Jim

 

[DougP]

Personally I think your VBA code is corrupted.<br>If you exahust all of your options then this is a last resort. PS I've had to do it too many times myself.<br><br>Create a new blank Access database and Import everthing that will come over.<br>Everything that won't will have to be re-created.<br><br>Also check in the FAQ's for making a .MDE (there are 2 FAQ's read them both). That will fix your problem in the future.<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.