CurrentProject.Connection error Access 2003 Runtime

[Guest]

I am installing an Access.mdb app (that uses a SQL-server backend) on an XP
Professional SP2 computer. The installation runs on Access 2003 runtime. The
first time it runs, it looks for existing SQL servers and let's the user
select the correct server from a combo box. Works great until it executes the
following:
dim cnn as ADODB.Connection
set cnn = CurrentProject.Connection
It recognizes the CurrentProject object (Debug.Print CurrentProject.Name
works fine), but it raises a 429 error ("ActiveX can't create object") on
execution of the above.
What am I doing wrong?

 

[Michel Walsh]

HI,


Probably something wrong with an installation of MDAC. Try to repair (if
that exists for your version, or re-install) MS Access.


Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

Michael,
Please see the following link for the trick that worked! Thanks for your
response.

http://msdn.microsoft.com/newsgroup...f6e869-e742-46d7-b8d8-68a1178bef5f&sloc=en-us

Jay