Access XP -> 97

[Kev]

Hi,

I have made a small database in Access XP that uses Visual Basic 6.0 and DAO
3.6.

When I ran this database in Access 97 A few errors occurred. I have managed
to upgrade the DAO from 2.5 to 3.6 on the copy of Access 97 and have tested
that this works correctly.

This fixed some of the problems, however a lot of code still will not run
because Access 97 uses an older version of VB. I have attempted to update
this by downloading and installing the latest VB6 runtime executable from
Microsoft.

Any attempts to alter the 'Visual Basic for Applications' from the VB DLL
that Access 97 uses to the newly installed VB6 DLL results in the message
'Can't remove control or reference; in use'.

I'm confused because i can see the reference to the correct DLL in the list
of references but I am unable to deselect the old VB.

How do i get VB6 to work on Access 97?

TIA

Kev

 

[chas]

Hi Kev,

I don't think Access 97 will work with later versions of
VBA, it is hard coded to work with the DLL that it is
supplied with.

Your best bet is to convert the Access 2002 database to
Access 97 which should make the necessary reference
changes.

btw - DAO 2.5 is for Access 2.0 not Access 97 which uses
DAO 3.5 - or was that a typo )

hth

chas

 

[Kev]

Hi Kev,

I don't think Access 97 will work with later versions of
VBA, it is hard coded to work with the DLL that it is
supplied with.

Your best bet is to convert the Access 2002 database to
Access 97 which should make the necessary reference
changes.

btw - DAO 2.5 is for Access 2.0 not Access 97 which uses
DAO 3.5 - or was that a typo )

hth

chas

Doh! that was the one answer i was hoping i wouldn't hear

I'll guess i'll be posting some messages later asking for equivalent bits of
code...

Thanks for your help anyway.

Kev