ActiveX Error

Sharad

Registered User.
Local time
Today, 03:01
Joined
Jan 23, 2003
Messages
26
I'm working with Access 97 on a windows XP environment and I have a simple create database connection snippet that is giving me the following Error:

"Run Time Error 429"

ActiveX component can't create object.

This is failing on the the line reading: Set Brent = OpenDatabase("c:\abc.mdb")

Dim Brent As Database
Dim rstA As Recordset

Set Brent = OpenDatabase("c:\abc.mdb")
Set rstA = Brent.OpenRecordset("tblCars")
Dim qrydef As QueryDef

Set qrydef = Brent.CreateQueryDef("Abc", "Select * from tblCars")

Any Help in this area will be appriciated!

Thanks
 

Users who are viewing this thread

Back
Top Bottom