Re: Seeing Access 2003 table in Access 2007

The reason you're not able to compile is likely because code is running. You
need to ensure no code is active before you'll be able to compile.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"linda" <linda@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FBA36308-E310-4B6C-9D05-0F034D2955E7@xxxxxxxxxxxxxxxx
Hi Tom,

Thank you so much to your reply. I really appreciate it. Part of what
you
said to do worked, but not all of it did.

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.

This worked great. Access now opens up without the warning.

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.

This part also worked great. I had a second missing reference which I
also
removed.

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.

However, when I selected Debug, almost everything was grayed out. The
only
compile possibility was grayed out, and it was to an older version of the
database. (I started using Access at the very first version.) Did I do
something wrong here?

Also, I am still not getting anything to show up in the main part of the
window. The list of tables/forms/reports looks complete, so I know
something
is there.

The "Navigate to Category" is set to "Object Type". Is that reasonable?

Thanks so much,
Linda

"Tom Wickerath" wrote:

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.


.

Loading