?
Solved

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

Posted on 2010-09-10
9
Medium Priority
?
5,859 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1064 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 536 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 - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1064 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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

801 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