Visual Basic Access

Hi,

I would like some advice on Visual Basic Access. I have put the following bits of code in VB.

Option Compare Database
Option Explicit

Dim RS As New ADODB.Recordset

But for some reason it is coming back with an error saying that it can't recognise it. Are there particular settings or declarions that need to be put in place before the code will work?

Hope you can help.

Cheers

Dave

Read VB6 ADO tutorials in Database Development FAQ - it has enough information to get you started.

Code:

---

Option Compare Database

---

This doesn't exist in VB4/5/6, are you talking about VBA?