Default Query Type

[Guest]

Hello,

Is there any way to set the default recordset type for queries so that
whenever a user creates a query in Access 2000, it will default to Snapshot
instead of Dynaset? And can this setting be done at the database level, so
that only the specific database we want to set this way will default to
snapshot while other databases we have will still default to dynaset?

We are looking to do this because we have one Access database that has a
bunch of linked tables via ODBC (to SQL Server) and users are always running
queries and keeping them open and causing problems with others who are trying
to modify data in SQL Server via a separate front end. We've tried setting
the Default Record locking to Edited Record and Open Databases using
Record-level locking, but for some reason ODBC in Access 2000 seems to want
to lock the whole table. Only when I set the recordset type in the queries to
Snaphot did it cease to lock the table.

Thanks in advance for your assistance.

 

[Guest]

Hi.

Is there any way to set the default recordset type for queries so that
whenever a user creates a query in Access 2000, it will default to Snapshot
instead of Dynaset?

No. The default Recordset Type is Dynaset, and there is no setting to
change this. In addition, there is no exposed property for the Recordset
Type in order to change it programmatically, so the only way to change it is
to open the query in Design View, then open the Properties dialog window and
manually change the Recordset Type from Dynaset to Snapshot, then save the
query.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.