Avatar of okamon
okamon

asked on 

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

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. User generated image User generated image
Microsoft AccessDatabases

Avatar of undefined
Last Comment
okamon
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Well, you are going to need to fix the reference.  Do you know how to do that?

mx
Avatar of Jerry Miller
Jerry Miller
Flag of United States of America image

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.
Avatar of Jerry Miller
Jerry Miller
Flag of United States of America image

On XP, it is located @ C:\WINNT\system32
Avatar of okamon
okamon

ASKER

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?  
SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Jerry Miller
Jerry Miller
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of okamon
okamon

ASKER

>> 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?
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo