No ADODB?? 1

[ParaTrooper]

I get an error on this piece of code:

Dim rs1 As ADODB.Recordset

The error is:
Microsoft VB compile error: "User-defined Type not defined"

I 'inherited' this database from a co-worker that has left, but I think it might be some problem with the database options.

Any help is much appreciated.
Jim.

 

[Quintios]

Shoot, I can't find the post where I answered this question the other day.

Basically you're missing a reference library. You can select which libraries are available while you're working on VBA code. Here's how you get there:


1. On the Tools menu, click References. The References command on the Tools menu is available only when a Module window is open and active in Design view.
2. Select the check boxes for those applications whose type libraries you want to reference.

You need one of the ADO (ActiveX Data Objects) libraries. Scroll down and pick the one with the latest version. No need to "push" it up the list; it will automatically move to the top along with the other libraries.

Have fun!

Onwards,

Q-