Missing vba332.dll (WINXP/Access 2003 SP-1)

[mrabrams]

I have the challenge (headache) of converting all of our databases from Access 97 to Access 2003.
So far, it hasn't been too bad, until I got this error trying to open one of the databases:

[i][b]Runtime error

[Francois]

I have 3 pc, one with Office 2003, one with Office 2000 and one with Office97.
On the pc with Office 2003, I do not have this file. (Full install)
On the pc's with Office 2000 and 97 I find the file in the directory :
C:Program FilesCommon FilesMicrosoft SharedVBA

On my Office 97 SP1 cd I find the file in :
cdDriveLetter:OSSystemVBA332.DLL
It has the same size (1.560KB) and the same modified Date (08/01/1997)
Maybe you can just copy it and see what happens ?

[charlotte]

What is using that in your code? 2003 (along with 2000 and 2002) uses an entirely different development environment from 97 so I seriously doubt that you want or need that file on your PCs. It is the VBA reference for 97 and you would be better off finding the code that uses it if any, and updating it to use the current equivalent, which I believe is VBE6.dll.

[WendellB]

Adding to the discussion, you might benefit from the conversion toolkit released by Microsoft a couple of months ago. If you have lots of databases to convert, it is a very handy tool.

[mrabrams]

<hr>What is using that in your code<hr>

After reviewing the database once again, I have discovered (remembered) that I was using code to prevent the mouse scroll.
For those interested, here is the code that did prevent the mouse scroll when I was using WINXP and Access '97.
(We are going straight to Access 2003)

Long piece of code (almost 3,000 characters) moved to attachment by HansV

By moving the vba332.dll, I was able to OPEN the database, but the code to prevent the scroll does not work.
I am in the process of trying 2003 code to accomplish this.

I hope this helps someone else !

Michael

[mrabrams]

Thank you Hans.

Wendell - I am having my IT people get their hands on the conversion kit. Thank you for the heads up !

Michael

[WendellB]

FYI, it was released coincident with SP1 for Office 2003 - you can read a brief review of it here.

[mrabrams]

Thank you for that Wendell - it's a good read.

We have the conversion kit now and are in the process of utilizing it.

Have a good weekend !

Michael

[charlotte]

No, I wouldn't expect it to. VBA332.dll was based on VB5. Office 2000 and later are all based on VB6, so you won't be able to just copy a dll and make that kind of thing work.