Solved

MS Access 2010 : missing or broken reference to the file 'asctrls.ocx' version 1.0

Posted on 2010-09-10
9
5,387 Views
Last Modified: 2012-05-10
I am running access 2007 on a xp. I tried to share the database file with windows 7 pc running 64 bit on my network. I created a share folder on xp and tried to access on win 7 pc, but I got the following pop up message : missing or broken reference to the file 'asctrls.ocx' version 1.0

Eventually I can open my database, but it seems I am not able to save it and if I open first on win 7 pc and then on xp I will not be able to open it. 1 2
0
Comment
Question by:okamon
  • 3
  • 3
  • 3
9 Comments
 
LVL 75
ID: 33652107
Well, you are going to need to fix the reference.  Do you know how to do that?

mx
0
 
LVL 18

Expert Comment

by:Jerry Miller
ID: 33652123
Click on the Database tools tab and open the VBA editor. Then choose Tools>References. Click on the 'asctrls.ocx'  reference. It should be marked as Missing. Then click browse and find it on your computer.
0
 
LVL 18

Expert Comment

by:Jerry Miller
ID: 33652128
On XP, it is located @ C:\WINNT\system32
0
 

Author Comment

by:okamon
ID: 33653444
where do I locate VBA editor on windows 7? I should only do it on te pc having problem right? In my case, it will be win 7 pc?  
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 266 total points
ID: 33653990
"where do I locate VBA editor on windows 7? "
It's part of Office/Access, not Windows per se.
Open Access.
If there are no existing Modules, click to create a new one; or open an existing one.  Either way will expose the VBA Editor.  Then from the menu, Tools>>References.  Look at the list and see if any show:

**MIssing <SomeReferenceName>

Resolve the issue by finding the missing reference, which according to JM79 is in the Win32 folder.

"I should only do it on te pc having problem right?'
Well, it would seem for starters.  You need to do it on whatever PC's have an issue.
0
 
LVL 18

Accepted Solution

by:
Jerry Miller earned 134 total points
ID: 33655194
In Access 2010:
Click on the Database tools tab and open the VBA editor. Then choose Tools>References. Click on the 'asctrls.ocx'  reference. It should be marked as Missing. Then click browse and find it on your computer.
0
 

Author Comment

by:okamon
ID: 33657247
>> Click on the 'asctrls.ocx'  reference. It should be marked as Missing. Then click browse and find it on your computer.

will it be somewhere on my local pc or it is on the pc which shared the database? and it should be in which folder?
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 266 total points
ID: 33657536
s/b your local PC.  If you are not sure where it is, you can do a search using Windows explorer ...

mx
0
 

Author Comment

by:okamon
ID: 33657759
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now