Seeing Access 2003 table in Access 2007

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.

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 CtrlG 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/Ac...nceErrors.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/ex...tributors.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.

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 CtrlG 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 CtrlG 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/Ac...nceErrors.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/ex...tributors.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.

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" wrote in message
...
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 CtrlG 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 CtrlG 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/Ac...nceErrors.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/ex...tributors.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.

Hi Doug and Tom,

Now I feel really silly. My husband was playing around with Access, and
found that by double clicking the table/report/form, the data appeared in the
main part of the screen. I had only been doing a single click (selecting).

Thanks again for your help.
Linda


"Douglas J. Steele" wrote:

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" wrote in message
...
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 CtrlG 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 CtrlG 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/Ac...nceErrors.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/ex...tributors.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.

Hi Linda,

Glad to hear that all is okay now.

On the Debug | Compile {ProjectName} from my earlier reply, you want to see
this option unavailable (greyed out). That's a good sign. If you make any
change at all in your code, even adding a single space somewhere, then the
code should become decompiled, and the Compile {ProjectName} item will once
again be available, assuming, of course, that you are not currently running
any code.

While you are exploring the Visual Basic Editor (VBE), I recommend that you
click on Tools | Options, and make the following changes:

Editor Tab
Auto Syntax Check ---Uncheck this
Require Variable Declaration ---Enable (check) this option

General Tab
Background Compile ---Uncheck this
Compile On Demand ---Uncheck this

I have a short Gem Tip that covers the variable declaration option, he

Always Use Option Explicit
http://www.access.qbuilt.com/html/ge...tml#VBEOptions


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

"linda" wrote:

Hi Doug and Tom,

Now I feel really silly. My husband was playing around with Access, and
found that by double clicking the table/report/form, the data appeared in the
main part of the screen. I had only been doing a single click (selecting).

Thanks again for your help.
Linda