error in ADOBD.Connection

[boligoma]

Hi, maybe this is a dumm question buy I'm new in VBA and I don't know what is missing. I want to get data from an Access database but I can't use the Connection object and I don't know why. I tried:

Dim Conn As ADOBD.Connection
(the error here is: User-define type not defined)

--------
Dim Conn
Set Conn = CreateObject("ADOBD.Connection")
(The error here is: ActiveX component can't create object)

I'm using plain and simple VBA from Excel 2003 (the database is in Access 2003), maybe I'm missing a plug-in, dll or library to run this out. I've alredy declare an ODBC, but I can't declare it because the connection is not working.

I also tried to use the tools-references to set-up the libraries and still is not working.

Some ideas?... thanks...

 

[HarleyQuinn]

Hi,

You may want to use ADO[red]DB[/red].Connection

You will also need a refernce to the Microsoft ActiveX 2.x Object Library.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.