Reference to DAO2535.tlb

  • Thread starter Thread starter Francois Grenier
  • Start date Start date
F

Francois Grenier

Hi!

I am in the process of migrating many Access 97 databases
to Access XP. One of the database uses old Dynaset and
Snapshot objects and works fine in Access 97 because it
still supports these objects through dao2535.tlb.

As expected, this database does not work in Access XP
beacause the type library is not installed. I cannot
simply reference the new version of the library (3.6)
because the code is not supported and I don't want to
change it. However, copying the Dao2535.tlb in the
folder where the database is located seems to solve the
problem (Access is able to reference the library :
Microsoft KB #286300).

I know Microsoft recommends upprgading the VBA code to
DAO version 3.60 using RecordSet but I would like to know
if the solution I used will cause me some problems...

Has anyone tested it? Is there an impact on the
performance of the application?

Thanks!

Francois Grenier
IS Manager - EDUMICRO inc.
 
It might appear to work and allow you to compile the db, but that type lib
is mean for DAO 3.5, not 3.6 (and there are some difference) which is what
comes with Access Xp. It will be work and take some time, but on this
score you should follow MS' recommendation and update to the code to DAO
3.6. Use a search and replace utility (e.g. www.rickworld.com) and that
should speed up the process greatly.
 
I have an Access 97 database that has worked fine for
years. My company is upgrading to XP. To work on XP I
had to copy in dao2535.tlb as you say. Doing certain
modules pegs out the CPU and the program goes to 'no
response'. Have you had this happen? See any way around
it?
 
Back
Top