CurrentProject.Connection error Access 2003 Runtime

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top