Error with upgrade to Access 2003

[KokoKity]

I am trying to upgrade an exisitng database to Access
2003. When I try to open the database in Access 2003 I
get error messages. The first warning says unsafe
expressions are not blocked..." and then it asks for an
update of Microsoft Jet Service Pack 8. I have now
installed that from the Microsoft website.

The next message says "Your database or project contains
a missing or broken reference to the file 'dao2535.tlb'
version 3.5. To ensure that your database or project
works properly, you must fix this reference."

Article 824259 discusses this issue and tells me that I
need to create a reference to Microsoft DAO 3.6 Object
Library, but it doesn't tell me how.

How do I create a reference to the DAO 3.6 Object
Library? Is there anything else that I will need to do?

Thanks,
David

 

[Mike Wachal]

I am trying to upgrade an exisitng database to Access
2003. When I try to open the database in Access 2003 I
get error messages. The first warning says unsafe
expressions are not blocked..." and then it asks for an
update of Microsoft Jet Service Pack 8. I have now
installed that from the Microsoft website.

The next message says "Your database or project contains
a missing or broken reference to the file 'dao2535.tlb'
version 3.5. To ensure that your database or project
works properly, you must fix this reference."

Article 824259 discusses this issue and tells me that I
need to create a reference to Microsoft DAO 3.6 Object
Library, but it doesn't tell me how.

How do I create a reference to the DAO 3.6 Object
Library? Is there anything else that I will need to do?

Thanks,
David

Hi David,

The warning about installing Jet SP8 is expected behavior because Jet 4.0
SP8 is the minimum version of Jet required for Access 2003. That dialog is
just there to ensure that you have the right machine configuration to run
Access 2003. Since you've gotten that handled, on to the next issue...

In order to fix the issue regarding the missing reference, you need to
remove the missing reference and create a reference to the DAO 3.6 library.
The steps that allow you to remove and select references are documented at
http://office.microsoft.com/assistance/preview.aspx?AssetID=HP052788661033
&CTT=4&Origin=CH063648701033.

It is possible that you may need to modify some of the DAO code in your
database once you have changed DAO libraries. The DAO 2.5/3.5 compatibility
layer was shipped in previous versions of Access so that legacy Access
Basic code would run. Access Basic has not been used since Access 2.0, and
the compatibility library was finally removed in Access 2002. If you have
any code in your database that was written in a 1.x or 2.0 database, it is
possible that you may be using legacy DAO objects that need to be replaced.
An example of a legacy DAO object is the Snapshot object, as in:

Dim snp and Snapshot

which is replaced in DAO 3.6 by:

Dim rst As DAO.Recordset
Set rst = <object>.OpenRecordset(<source>, dbOpenSnapshot)

It is possible that you won't have to change anything, it just depends on
your code. Once you have updated the references, you will need to compile
your code. If there are no compilation errors, you're ready to go. If you
find compelation errors, you will need to fix them.

You can find information about other things that have changed in Access
2003 in the following help topics:

Introducing Access 2003:
http://office.microsoft.com/assistance/preview.aspx?AssetID=HA010714971033
&CTT=4&Origin=CH062525931033

Getting Started with Access 2003:
http://office.microsoft.com/assistance/preview.aspx?AssetID=HP051863841033
&CTT=4&Origin=CH062525931033

Migrating to Access 2003:
http://office.microsoft.com/assistance/preview.aspx?AssetID=HA010916581033
&CTT=4&Origin=CH062525931033

--
Regards,
Mike Wachal
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.