Error Converting Access97 DB to Access2002 DB

[Guest]

Hi,

I am attempting to convert a database created in Access97 to Access2002.
The database as various forms, macros, modules and queries. However, during
the conversion process an error message is returned:

Missing or broken VBE reference to the file 'dao2535.tlb'.

If I attempt to open the Access97 verision of the DB using MS Access 2002,
the message reads,

Your MS Access database or project contains a missing or broken reference to
the file 'dao2535.tlb' version 3.5'

How can this error be resolved? I don't have the original specs on how this
database was defined, so if I can't convert it, I am not sure how I can get
this database to work on Windows XP (which is the ultimate goal).

Thanks in advance for any assistance,
K.

"

 

[Van T. Dinh]

It sounds like your database was set up originally in an Access version
earlier than Access97.

Using Access97 software, remove the broken Reference and add the Reference
"Microsoft Data Access Object (DAO) Library" to the References Collection.
Recompile and test your database. When it is OK, try using Access2002 to
convert the database again.

 

[Brendan Reynolds]

The database has a reference to the DAO 2.x/3.x Compatibility Library, which
allowed databases developed in Access 2 to work with Access 95 and Access 97
without updating obsolete DAO 2.x code. There isn't any version of this
library for DAO 3.6 (the version of DAO used by Access 2000 and later) so
the obsolete DAO code has to be updated before converting to any version of
Access later than Access 97.

In Access 97, open any module, then select References from the Tools menu.
Uncheck the DAO 2.x/3.x Compatibility Library reference, and check the
Microsoft DAO 3.51 Object Library. Try to compile, and the first line of
obsolete DAO 2.x code will be highlighted. Fix it, then attempt to compile
again to find the next line that needs fixing. Repeat until there are no
more compile errors. Then you can convert.

Changes necessary include ...

1) The BeginTrans, CommitTrans, and RollBack methods are now methods of the
Workspace object instead of the Database object.
2) You can no longer refer to fields of a recordset using
RecordsetObject.FieldName, you have to change it to
RecordsetObject!FieldName ("!" instead of ".") or
RecordsetObject("FieldName").
3) The way QueryDef objects are defined has changed. In DAO 3.x it's Set
QueryDefObject = DatabaseObject.QueryDefs("QueryDefName"), in DAO 2.x it was
.... um ... I always forget this one ... I seem to have some kind of mental
block about it ... OpenQueryDef, something like that?

 

[Tom Wickerath]

Your database is using the older DAO compatibility layer. The solution is to remove the reference
to the "Microsoft 2.5/3.51 Compatibility Layer", and add a reference to the "Microsoft DAO 3.6
Object Library". Then click on OK to dismiss the references dialog. Click on Debug > Compile
DatabaseName. Correct any compile errors that you find, by converting older DAO code to present
coding standards. This KB article should help you:

You may receive compile errors after you open or convert a database that has older DAO code in
Access 2002
http://support.microsoft.com/?id=313233


Tom
_______________________________


Hi,

I am attempting to convert a database created in Access97 to Access2002.
The database as various forms, macros, modules and queries. However, during
the conversion process an error message is returned:

Missing or broken VBE reference to the file 'dao2535.tlb'.

If I attempt to open the Access97 verision of the DB using MS Access 2002,
the message reads,

Your MS Access database or project contains a missing or broken reference to
the file 'dao2535.tlb' version 3.5'

How can this error be resolved? I don't have the original specs on how this
database was defined, so if I can't convert it, I am not sure how I can get
this database to work on Windows XP (which is the ultimate goal).

Thanks in advance for any assistance,
K.

"