Problem with ADO

[minckle]

I've got MS Access 2003 installd on my computer

i get an error when running the following code

Code:

Public Sub test()
Set a = New ADODB.Connection
End Sub

Error msg:
Runtime Error '429': ActiveX component can't create object

Any 1 got any ideas???

Not sure if this helps - under references i have 'Microsoft ActiveX Data Objects 2.8 Library' ticked

 

[cmmrfrds]

Either
Dim a as adodb.connection
Set a = New ADODB.Connection
OR
Dim a as New adodb.connection