Northwind Database

[Guest]

Opening a recordset
The code is as follows:

Sub RecordsetOpenTable
Dim rs As ADODB.Recordset
End Sub

Set rs = CreateObject("ADODB.Recordset")
"Book States"

Caution (Pryor to running any code be sure the
Database is closed?) where do I run the code
from?
In VB 2005 I knew if I was pluged in, but I am not
sure in Access.
If the Northwind database is open
am I connected to the database?

 

[pietlinden]

Opening a recordset
The code is as follows:

Sub RecordsetOpenTable
Dim rs As ADODB.Recordset
End Sub

Set rs = CreateObject("ADODB.Recordset")
"Book States"

Caution (Pryor to running any code be sure the
Database is closed?) where do I run the code
from?
In VB 2005 I knew if I was pluged in, but I am not
sure in Access.
If the Northwind database is open
am I connected to the database?

Read up on ADO in the help file - connection and command objects. If
this is a VB.Net question, you should ask there...