Your Microsoft Office Access database or project contains a missing broken reference

[funkeymonkey]

Please Help !
I am problems accessing any 2003 or earlier databases using microsoft office 2007. Every time I try and open a database file I get the message 'Your Microsoft Office Access database or project contains a missing broken reference to the file 'AITOOL.DLL' version 1.0. I've had the ultimate version installed, removed it and replaced with enterprise version but I still get this message. I can create a new database fine. Any ideas welcome.

[puppydogbuddy]

Please Help !
I am problems accessing any 2003 or earlier databases using microsoft office 2007. Every time I try and open a database file I get the message 'Your Microsoft Office Access database or project contains a missing broken reference to the file 'AITOOL.DLL' version 1.0. I've had the ultimate version installed, removed it and replaced with enterprise version but I still get this message. I can create a new database fine. Any ideas welcome.

As I understand it, you will need to create a certificate for yourself in order to run an earlier version of Access with Office 2007. If you have not 'self certified' your database with a trusted certificate. Office 2007 will not run code that has not been certified. See this link:
http://office.microsoft.com/en-us/ac...397921033.aspx

[hyperpau]

As I understand it, you will need to create a certificate for yourself in order to run an earlier version of Access with Office 2007. If you have not 'self certified' your database with a trusted certificate. Office 2007 will not run code that has not been certified. See this link:
http://office.microsoft.com/en-us/ac...397921033.aspx

The answer to this is simple. As soon as you open
your database and see that error, close that error.
Then go to the forms. and open any form in design view.
On the design view of the form, click the Code button
to launch Microsoft Visual Basic.
In Microsoft Visual Basic, click on the Tools menu and select
reference. On the popup box, you would see items
with check boxes. look for that item that says: MISSING: ....
and uncheck the checkbox. SAve it.
You would no longer see that error.! :)