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
"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