>I am running an Access 2002 database on a Windows 98 machine loaded with
>OfficeXP. The machine I developed on is running Windows XP version 2002. I
[quoted text clipped - 5 lines]
>The code on the On Open Event seems to be stopping here.
>Set con = Application.CurrentProject.Connection
If this was a DAO function then you'd probably need to register the
DAO dll using regsvr32. For example regsvr32 "C:\Program Files\Common
Files\Microsoft Shared\DAO\DAO350.DLL" or DAO360.DLL
However given that it's ADO you probably need to muck a bit with MDAC.
See ACC2002: Err Msg: "ActiveX Component Can't Create Object"
http://support.microsoft.com/support/kb/articles/q304/1/73.asp
Tony

Signature
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
dmc - 28 Jul 2006 20:01 GMT
Thanks Tony, I will try this solution
> >I am running an Access 2002 database on a Windows 98 machine loaded with
> >OfficeXP. The machine I developed on is running Windows XP version 2002. I
[quoted text clipped - 15 lines]
>
> Tony