[AccessD] Compile errors

On 7/10/07, Jim Lawrence <accessd at shaw.ca> wrote:

> Has anyone had a similar error: "compile error:  User defined type not
> defined" I can not duplicate the error on my system and the client can not
> resolve the error on their system. They have the complete application, to
> the letter, running on their site.
>
> What could be causing this error as it appears they have virtually the same
> MS Access version that I do?

Jet SP levels is what I have found causes these errors.

I had this error once because I had Jet SP6 and the users workstations
had Jet SP3. Once I upgraded the workstations to Jet SP6 the error
went away.

MS has a tool, MDAC Utility: Component Checker, to see what versions
and SP level the install is at.

-- 
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"