dao2535.tlb and comctl32.ocx errors

[Melissa W]

I have a database that was created in Access 97 and have
not recieved a new PC with Access 2002 on it. I tried to
convert the database to 2002 but now when I go to open it
I get the following errors.
------
Your task management system database or project contains a
missing or broken reference to the file dao2535.tlb
version 3.5.
To ensure that your database of project works properly,
you must fix this reference.
To Learn how to fix this reference click Help.

OK - Help
------
I can't get much help from the help section. When I click
OK I get eth same error but this time with comctl32.ocx in
place of dao2535.tlb.

Can someone point me in the right direction?

Thank you

 

[Roger Carlson]

The database must have originally been created in Access 2.0 and converted
to 97. During that conversion process, Access 97 installed the DAO 2.5/3.5
Compatibility Library, which acted as a bridge between Access Basic (used by
Access 2.0) to Visual Basic (used by Access 97). To convert this to Access
2000+, you need to remove this reference and correct any errors that arise.
There are not all that many. VBA has a few more reserverd words than
AccessBasic, and if you used them in your old program, they might cause
errors. Also, AccessBasic was more forgiving of bang (!) and dot (.) used
incorrectly.

You shouldn't need to find and install this reference. The thing to do is
open it in Access97 somewhere, uncheck the reference, correct any errors,
then continue with the upgrade.