Recordset Type: Snapshot question

[dgunner71]

All,

As I'm working through an odd locking issue (separate post), I'm wondering if it is best (or at all beneficial) to employ snapshot RecordSet types (on forms) - specifically where I would never need to update information.

The Scenario:

I have a search form where the search criteria fields are contained on the parent form and the results of the search are contained on a continuous subform. From my reading, I understand that setting the subform (in this instance) recordset type to Snapshot is ideal where the data will not need to be updated (perfect for a search form).

Aside from holding less in memory, (the snapshot is just that - a snapshot of the data at a given point in time), I'm wondering if this might possibly alleviate another problem I have where RunSQL statements are encountering a locked record issue.

I'd love to hear your thoughts and experiences with using the Snapshot RecordSet Type on forms. Reasons, Do's, Don'ts, and strategies.

Thanks!

Gunner

[jimatqsi]

Using snapshot recordsets helps greatly to speed up some data access. It's never helpful to lock records unnecessarily. So long as you don't need the rs to be update-able you should use it.

One caveat is that you should be sure to limit the rs with appropriate where clause because the entire rs will be pulled when you open it.

Jim

[dgunner71]

Thanks, Jimatqsi for the direction.

I am planning to have the default form filter set to show the last 25 or 50 records created. This will be cleared when the user enters any searchable data in the parent form.

I will accomplish this through, showing records > (dmax([myID]) - 25). I have never had any luck using the 'Top 25' setting in the query properties. This doesn't seem to work properly with my search forms.

At any rate, thanks again.

Gunner

[jimatqsi]

Perhaps you should post an example of your top 25 problem sometime. I use that sometimes without any problem.

Jim

[dgunner71]

Jim,

Thanks for your offer to assist - I'll post this under a new topic (Query Top Values).

Thanks -

Gunner