Break Default VBA Reference

[strvariant]

Hi all,

I have an Access 97 database that has as one of it's default references the
VBA332.dll file. Our company has started upgrading users to Windows XP and
Office 2003, but because of so many Access 97 applications they are not
installing Access 2003 as part of their image. They are installing Access
97 into a separate folder.

I need to know if I can force Access 97 to break it's reference with
VBA332.dll and go with the VBA6.dll as the default reference or at least
change it at the references window. Every attempt so far has resulted in
the message about 'Access needs this reference...'.

Yes --- I know...Acc97 and Office 2003 on WinXP.

Thanks for the help,

strvariant

[Matthias Klaey]

strvariant <no.email.com> wrote:

Hi all,

I have an Access 97 database that has as one of it's default references the
VBA332.dll file. Our company has started upgrading users to Windows XP and
Office 2003, but because of so many Access 97 applications they are not
installing Access 2003 as part of their image. They are installing Access
97 into a separate folder.

I need to know if I can force Access 97 to break it's reference with
VBA332.dll and go with the VBA6.dll as the default reference or at least
change it at the references window. Every attempt so far has resulted in
the message about 'Access needs this reference...'.

Yes --- I know...Acc97 and Office 2003 on WinXP.

Thanks for the help,

strvariant

AFAIK you cannot run Access97 with anything else than VBA332.dll,
period. Why can't you just simply keep this dll?

HTH
Matthias Kläy
--
www.kcc.ch

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

[strvariant]

Matthias Klaey <mp**@hotmail.com> wrote in
news:9o********************************@4ax.com:

strvariant <no.email.com> wrote:

Hi all,

I have an Access 97 database that has as one of it's default
references the VBA332.dll file. Our company has started upgrading
users to Windows XP and Office 2003, but because of so many Access 97
applications they are not installing Access 2003 as part of their
image. They are installing Access 97 into a separate folder.

I need to know if I can force Access 97 to break it's reference with
VBA332.dll and go with the VBA6.dll as the default reference or at
least change it at the references window. Every attempt so far has
resulted in the message about 'Access needs this reference...'.

Yes --- I know...Acc97 and Office 2003 on WinXP.

Thanks for the help,

strvariant

AFAIK you cannot run Access97 with anything else than VBA332.dll,
period. Why can't you just simply keep this dll?

HTH
Matthias Kläy

Thanks for your reply,

Turns out that the reference that was causing the problem was a Lotus
Notes file. By changing the code to use 'late-binding' solved the
problem.

And you were right --- changing the vba332.dll reference was not possible
and ultimately not permitted under Access 97.

Thanks again for your help,

strvariant