I need some help...

[2Fasn8n4U]

Alright...
I found a database demo at vbsquare.com.
In the General Declarations it states

Dim DB As Database
Dime RS As RecordSet

Well... When I transfered that code to my existing project that I wanted to add the database too, it gave me an error. Appearantly it wont let me use 'Database' as an option.

But it will let me use 'Database' as an option in the demo I downloaded. What do I have to do???

[ExtremePimpness]

I'm not completly sure on this one but you might have to use a "type" statement

[2Fasn8n4U]

Well...
Yeah, I have to use a 'type' statement...

What kinda 'type' statement should I use???


Dim DB As Database


That doesn't seem to work with my program, but it does with the program I downloaded from vbsquare.com

[ExtremePimpness]

It should be contained in the other program if that prograam works correctly. other than that i'm not sure.

[Alfred]

To use the DAO database objects your project must have a reference to the file containing these DAO components. Use the project menu to open the reference (Menu Project > sub menu References) and look for the DAO components called:

Microsoft DAO 3.6 object library

(or version 2.5 or 3.51 etc.)
Select the the component and click Ok. Now your program can use the DAO objects like Database and Recordset.

[2Fasn8n4U]

I cant find the Microsoft DAO object library...

I have the Microsoft ADO Data Control 6.0 in my components list.

What can I do???

[Tonio169]

make sure you selected the References and not the Components menu option.