I am trying to change a bunch of queries (200 of them) to be snapshots not dynasets. The property is the recordset type. Can i change them all at one time from code? all the queries names have the first character as an underscore.
I think i should cycle through the queries in code then change the recordset type attribute for each. but i don't know how to get to that attribute. I declared an object as allqueries but it doesn't have that attribute.
any help would be great.