RE: Seeing Access 2003 table in Access 2007

Hi Linda,

The 'dao2535.tlb' reference is a fairly old reference, which should have
been eliminated several versions ago in Access. If my memory serves me
correctly (?), this particular reference should have been eliminated, with
VBA code re-written as needed, when upgrading from Access 95 to Access 97.
That said, perhaps it just accidently got checked somewhere along the line,
and you really don't need it.

Open Access 2007, and set the Trust Center settings to trust the folder that
you have saved this database into:

Dealing With The Trust Center (Access 2007)
http://www.accessmvp.com/TWickerath/articles/trust.htm

This way, VBA code in your database will not be disabled from the get-go.

Open your database while holding down the Shift key the entire time, to
disable a Startup form and/or Autoexec macro. Then press <Ctrl><G> to open up
the Visual Basic Editor. Click on Tools | References. Try removing the
checked reference to 'dao2535.tlb', and then click on the OK button to
dismiss this dialog. Then try compiling your VBA code, by clicking on Debug |
Compile {ProjectName}, where {ProjectName} is the name of your VBA project.
If you do not get any compile time errors, then you should be set, and can
try re-opening your database in the usual manner. Here are two very good
articles on the topic of missing references:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html


Then, when Access 2007 opens, my tables/reports/forms are listed on the
left, but nothing is displayed in the main part of the window.

Okay, this part sounds weird. See if this problem clears up, if you can
remove the missing reference, and compile your project without any errors.

Also, make sure that you install Service Pack 1 for Office 2007. There are
also some hotfixes that you should likely install.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

"linda" wrote:

I recently upgraded from Office 2003 to Office 2007. When opening Access
2007 and using my Access 2003 database, I get the error message
"Your Microsoft Office Access database or project contains a missing or
broken reference to the file 'dao2535.tlb' version 3.5."

I get this error message 11 times. I have no idea what this file is. Then,
when Access 2007 opens, my tables/reports/forms are listed on the left, but
nothing is displayed in the main part of the window.

How do I get my tables/reports/forms to display? Does this error message
have something to do with the problem?

Thanks.
.