Class Modules

[Alan]

First, thanks in advance to anyone that can help.

My background is: New to Class Modules, but not to Access.

I have a database that opens fine prior to adding a class
module which I found in the Access 2002 Desktop
Developer's Handbook, By Litwin, Getz, and Gunderloy,
Published by Sybex. {Class Module - Multipik }

The module works great until I turn the database over to
my end-user.

My problem:
My end-user was excited to use this new tool that I
found. Until she opened the file and got the Microsoft
error. The error stated that the database needed
repair. An error was encounter in the VBE6.DLL
We fixed it and the database opened.

Thinking I solved it, I attempted to open the database on
my machine, but ended up with the same Microsoft error.
After several days of research and trial and error, I
finally found a work around.

My work around is:
I open first a database that just contains the class
module, multipik. I open the VB editor. Now I switch
back to the database and I open the database in question,
and it opens fine.

I've have checked my references library and all the
libraries I believe I need is there. The libraries are:

Visual Basic For Applications
Microsoft Access 10.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library

Microsoft DAO 3.6 Object Library - was REMOVED

My question for help is:
1. Based on my work-around, do I need to pre-load the VB
libaries somewhere, somehow?
or
2. What I am doing is completely wrong?

Thanks again!

Alan

 

[GVaught]

Check the references on the user's machine. They might not have the same
references set. They may need an updated MDAC running. Are you sure the
module in the 2002 book is using ADO and not DAO? What happens if you remove
the reference to the ADO and add back the DAO? Do you get a different error?
When DAO 3.6 was set, did it appear before the ADO reference? Rather than
use ADO 2.1, which is way old, use a newer ADO, such as 2.7. (This comes
from a new MDAC download). It is free.
www.microsoft.com/downloads or search for MDAC 2.7.