• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 415
  • Last Modified:

Access 2007 problem

I have just installed Office 2007 on a new laptop, running Windows 7. I have been using this same program on my desktop computer, running Windows XP.
When I try to open a database on the new laptop the following message comes up:
Your Microsoft Office Access database or project contains a missing or broken reference to the file 'asctrls.ocz' version 1
* To ensure that your database or project works properly, you must fix this reference.
I have opened the Access and checked out the references and there are no missing references.
I am unable to open any files to check them out.
Can you help me with this because I need to be able to access these files from the laptop.
Pauline C
0
paulinehc
Asked:
paulinehc
4 Solutions
 
infolurkCommented:
The error occurs because an object in the database is trying to use an activex control that has changed between versions. You could try recompiling database modules.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Open the VBA Editor and click: Tools-->References

See if anything is marked "Missing"
Uncheck it and look for a reference with a similar name (but older version) and turn that on.
Then Click: Debug-->Compile
If no errors, then retest.

;-)

JeffCoachman
0
 
infolurkCommented:
Actually it looks like you will either have to install the asctrls.ocx control on your new machine or find the reference to the control in vba and disable it.

The control will probably be called "InstallEngineCtl Object" in your references.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you absolutely sure you need this control? From what I can tell, it's from a much older version of Windows (and you can't really "redistribute" it, at least from what I can tell.

You can test to see if you need this. Make a backup of your database, then do this:

1) Open the VBA Editor (Ctrl + G)
2) Click Debug - Compile. Fix any errors you find.
3) Click Tools - References. Uncheck the box next to that reference
4) Debug - Compile again

If you don't get any errors in Step #4, then in 99.99% of caes you don't need this reference (there is a small possibility that you'd need this with Late Binding, but it is very, very remote).
0
 
paulinehcAuthor Commented:
Thank you all so much. As soon as I saw the comments, I knew where the problem lay. It is now fixed and I can open the database. Very appreciative of the quick responses.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now