How do I access a module to fix a missing or broken reference?

[Guest]

I am receiving a message that I have a missing or broken reference in file
"doa2535.tbl" ver 3.5. I cannot find the reference after accessing the
Visual Basic Editor under "Macro" under "Tools" within my data base. I
cannot find any other way to view a "reference". I cannot find this file
when performing a search of the hard drive. How do I fix this?

 

[Douglas J. Steele]

What version of Access are you using? dao2335.tbl is a compatibility layer
that only works in Access 97. Odds are you should have a reference to DAO
3.6 instead.

 

[Guest]

Hi Douglas,
I am using Access 2003 but this database was orginally created in Access 97
and converted. The error message tells me this .tbl file is in version 3.5
Any ideas? Most of this terminology is way over my head!
Thanks for answering.
M.T. Blanch

 

[Douglas J Steele]

Open the VB Editor (Alt-F11)

Select Tools | References from the menu.

If any of the checked entries at the top of the list have MISSING: in front
of them, uncheck them (write down what they were, just in case...)

Go to the Debug menu, and select the Compile option. If you get no errors,
you should be done.

If you do get errors, pay attention to what the errors are. If they're
complaining about "user defined type" for declarations that dimension
variables to As Database, go back into the References dialog, scroll through
the list of available references until you find Microsoft DAO 3.6 Object
Library and select it. Do your Compile again.

If that doesn't solve the problem, report back what it's complaining about.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi Douglas,
I am using Access 2003 but this database was orginally created in Access 97
and converted. The error message tells me this .tbl file is in version 3.5
Any ideas? Most of this terminology is way over my head!
Thanks for answering.
M.T. Blanch