Changing default property values for select queries

[tskelton]

Hi, all. We use Access for querying and reporting of data that's in an Oracle-based datamart. After researching the subject of query performance, we have observed marked improvement in our query performance by changing the RecordSet Type in the query propery sheet from DynaSet (the default value) to Snapshot. Because we don't update the datamart through Access, this setting works great.

Now for my question... How can I set Access so the default RecordSet Type value for all new queries is Snapshot?

I have searched Microsoft's Knowledge Base and the Access Help files, but all I have found is information on changing the default values (like font, font size, etc.) of controls in forms and reports, but nothing about queries.

Thanks to any and all who respond with suggestions!

 

[Databaseguy]

If you're using 97 (DAO), look into the QueryDef object. You should be able to set it programatically.

With 2000, it's the Procedure property contained in the ADOX library (ADOX is not installed by default)

Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy