Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6079
  • Last Modified:

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. 1 2
0
okamon
Asked:
okamon
  • 3
  • 3
  • 3
3 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Well, you are going to need to fix the reference.  Do you know how to do that?

mx
0
 
Jerry MillerCommented:
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
 
Jerry MillerCommented:
On XP, it is located @ C:\WINNT\system32
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
okamonAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"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
 
Jerry MillerCommented:
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
 
okamonAuthor Commented:
>> 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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
s/b your local PC.  If you are not sure where it is, you can do a search using Windows explorer ...

mx
0
 
okamonAuthor Commented:
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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