Broken reference error

[Supe]

I created an Access(2003) database that I sent to another person who loaded
it on her PC. When she tries to open it she get the error message: "The data
base contains a missing or broken reference to the file msadomd.d11". She
also has Access 2003. Any suggestions?

 

[Lorenzo\(pyx\)]

In

I created an Access(2003) database that I sent to another person who
loaded it on her PC. When she tries to open it she get the error
message: "The data base contains a missing or broken reference to the
file msadomd.d11". She also has Access 2003. Any suggestions?

Hello,
Try from inside a module (any) , Tools->Reference
It's possible that the DLL (msadomd.dll) is missing
or unregistered.

Try to reinstall MDAC:
http://msdn.microsoft.com/data/ref/mdac/

Also check on your database if you need this reference.

I hope this can help you.

 

[Tony Toews]

I created an Access(2003) database that I sent to another person who loaded
it on her PC. When she tries to open it she get the error message: "The data
base contains a missing or broken reference to the file msadomd.d11". She
also has Access 2003.

Do you need that DLL? Likely not.

Do you have any references besides the basic three? Are you sure you
need them? Write down the path and name of the extra ones, delete
from the references list and Compile and Save All. Keep any
necessary references and ensure they are distributed to the target
system.

For a very detailed page on reference problems see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

The Access 2003 default references when the MDB is in A2000 format are
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library

The Access 2003 default references when the MDB is in A2002/A2003
format are
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.5 Library

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm