access database tables

[AP Fritts]

ok, i have a database with a table called "employees"

is there a way that I can have the contents of that table returned to me as
an ADODB.Recordset object?

If not, my next question is how can I get a set of records that meet certain
criteria?

Thanx,
AP

 

[AP Fritts]

I figured it out.

Dim rs As New ADODB.Recordset
rs.open "employees", CurrentProject.Connection