Error when clicking button on form

G

Guest

I have a database which i have inherited from someone who has now left the
company.
There are 2 versions of the front end an mdb and an mde version and the back
end where the tables/data is stored.
The problem i am having is that when i click one of the buttons on the first
form in order to bring up a second data entry form i get an error message of:
"Your Outbound Database 1.1 database or project contains a missing or broken
reference to the file 'CommCtls.ocx' version 6.0"
I can't find any reference to this file in any code!!
This error does not appear in the .mde version
the mde version is named Outbound Database 2.2 would this have any effect??
I think the root of the problem may be that the person who left has left us
an out of date copy of the Development database
Any thoughts??
 
N

Nikos Yannacopoulos

Danny,

Your problem has to do with the registration of CommCtls.ocx (Common
Controls ActiveX control), or even the absence of it, and is
machine-specific. It's actually a missing key in the registry so Windows
"knows" where to find the commctls.ocx file (provided it exists on the
machine).

To fix:
1. Locate the file in your HDD; most likely places are under
Windows\System32 or somewhere under Program Files\Microsoft Office. If
you find it just note the location; if not, copy the file from the
machine where it works, and paste it in Windows\System32.
2. Open a database in Access (any database) and go Tools > ActiveX
Controls, click on Register, browse to the file location, select it and
click OK. This should fix the problem.

Now, whether the development copy is the latest version or not: if the
..mde works on the same machine where the .mdb doesn't (before you apply
the fix, of course) then you can be positive that the development copy
is an older version, since the particular ActiveX control is no longer
used in the .mde. If the .mde produces the same error message, you can't
really know, except that the .mde still uses the same ActiveX control,
whether a later version or not.

HTH,
Nikos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top