Requery Pass-Through Query

[rookery]

I've opened a recordset based on a pass through query which pulls all the records back from a SQL table

eg.

Set rs1 = ThisDB.OpenRecordset("passthroughquery1", dbOpenSnapshot, dbSeeChanges)

The problem is when I try and requery the recordset later on I get a:

"Operation is not supported for this type of object error".

Has anyone got any suggestions?

 

[PHV]

I don't think you can requery a dbOpenSnapshot recordset.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[rookery]

Thanks anyway but not true. Tried changing it to dbOpenDynaset and it still didnt execute.

Also it works quite happily when I use the name of the table.