Type Mismatch in OpenRecordset - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Type Mismatch in OpenRecordset

MJablinMJablin Posts: 2Member
I'm trying to set a recordset using an SQL string and the OpenRecordset function.

Set rstTemp = dbs.OpenRecordset(strSQL, dbOpenSnapshot)

I use similar code in another database, and it works fine there. It doesn't matter what query I put into strSQL, it won't run. I can run the query in the database, but it doesn't work in the VBA code. Any ideas? Thanks.

Sign In or Register to comment.