Link to home
Start Free TrialLog in
Avatar of Lawrence Salvucci
Lawrence SalvucciFlag for United States of America

asked on

Access Runtime 2010 Error

I have a laptop that is running Access 2010 Runtime version. When I try to open a database with that version I get an error message when the AutoExec fires. The error message is attached in the picture. When I open this DB in a licensed full version of Access it works fine. What is it about the runtime version that would cause this error? This isn't a very elaborate database and doesn't have much code to it. How can I fix this to run on the runtime 2010 version?
Error1.JPG
SOLUTION
Avatar of Anders Ebro (Microsoft MVP)
Anders Ebro (Microsoft MVP)
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Lawrence Salvucci

ASKER

I did that and there were no errors or highlighted bits of code that could not compile. It compiled 100%.
Again, open the VBA Editor >> Tools >> References
Look for :

**MISSING <SomeReferenceName>

if found ... resolve the missing Reference
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I see no missing references. Let me ask a question....I am using a full version of A2007 and the laptop is running A2010 Runtime. Would I not see any missing references in my A2007 version?
Is your Access 2007 version fully updated, and has the latest service packs?
Yes it is.
"Would I not see any missing references in my A2007 version?"
Opening in A2007 enviroment may not expose a Reference issue when trying to run in a A2010 environment.
If your code is compiling ... then kind of seems like a Reference problem in the A2010 environment.
Was this working already and just started happening ?
Crystal,

Here are the libraries I am referencing

Visual Basic for Applications
Microsoft Access 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Access database engine Object Library
Microsoft CDO for Windows 2000 Library
Microsoft ActiveX Data Objects 2.8 Library

I am using the full version of A2007 and the runtime is A2010
I just tested it in a full version of 2010 and it worked fine and no missing references. I also have runtime 2007 versions that use this same DB and it works fine.
It just started happening when I loaded the 2010 version on one of my laptops.
So ... it's failing on a laptop with just A2010 Runtime ?
Ok I was just informed that this laptop had a trial version of A2016 on it. This database was working fine on that trial version. When it expired they uninstalled that version and installed the 2010 runtime version and that's when it wouldn't work anymore. What does that tell you? Are there drivers still on there from the A2016 version that are causing it to error out?
Tells me it might be kind of a mess :-(
Might be some A2016 remnants lurking around in the Registry .... not sure.
I'm gonna have them try to clean it up somehow. I'm guessing that's the problem.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial