By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,453 Members | 937 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,453 IT Pros & Developers. It's quick & easy.

Recordset Type: Snapshot question

100+
P: 110
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
Apr 3 '14 #1

✓ answered by 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

Share this Question
Share on Google+
4 Replies


Expert 100+
P: 1,240
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
Apr 3 '14 #2

100+
P: 110
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
Apr 3 '14 #3

Expert 100+
P: 1,240
Perhaps you should post an example of your top 25 problem sometime. I use that sometimes without any problem.

Jim
Apr 3 '14 #4

100+
P: 110
Jim,

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

Thanks -

Gunner
Apr 3 '14 #5

Post your reply

Sign in to post your reply or Sign up for a free account.