how do i open a record set?

M

mike g

Hi simple question
i want to open a record set
eg. this code in in a visual basis module..
Dim rs As Recordset

Set rs = CurrentDb.OpenRecordset("select * from table")

I get run time error 13, type mismatch? huh?
I am using access 2002 this used to work in previous
access versions? do i need to use ado or something?

thanks
mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recordset in Access 2007 1
Recordset show previous record when no matching record found 1
ADO Not Opening Recordset 2
using recordset findfirst 7
adOpenStatic Recordset still changing my table 5
Running command line command without the DOS window 7
My string does not want to execute 5
docmd send object sending all records to each person 1

Top