Access does not show all records when opening

[ruttrowgeorge]

If I open a 2010 database on the network, it only shows 128 records.
If I open it locally on my workstation I see all 4800 rows/records.



What would cause this?
Thanks

[ItsMe]

When using the network, what happens if you click the last record button and wait for the entire dataset to load?

[ruttrowgeorge]

It then shows all 4803 records if you do this. My fear is my end users will not understand doing that every time.

[ItsMe]

It is simply a speed issue. The network is not as fast as the bus on your PC. There are different types of queries. You can edit some datasets and you cannot edit others. One thing you can do is start to distinguish your queries between the two and limit the number of records retrieved by them.

It is typical that a query will be a Dynaset. You will want this to be the case when there is a need for edits to the records being retrieved. If you do not need to make edits, you can set your query's properties so that it retrieves a Snapshot vs. a Dynaset. Setting the properties of a query as a Snapshot will simulate clicking the last record button of the Navigation Buttons. The Snapshot will retrieve all of the records before displaying any of the records. A Dynaset will retrieve a percentage of the records to display. As you navigate through the Dynaset, additional records will be retrieved.

The downside to a snapshot is that the user will have to wait while the entire dataset is loaded into memory. If the PC does not have a lot of horsepower and or the network is slow, this may not be acceptable. The best practice thing to do is limit the size of the entire dataset, upfront. If the user does not need to review 4,300 records, do not include 4,300 records in the query. Add criteria to a WHERE clause to retrieve only relevant data.

[ruttrowgeorge]

How does one change a database from Dynaset to snapshot?

[ranman256]

the filter could be on when open. mine does.

[ruttrowgeorge]

No filters are showing on the bottom when opening. I am wondering, since this only happens in Citrix, if a Microsoft update (Office or Windows 2008 R2) is playing a role in this issue.

[ItsMe]

To keep things simple, I will say that you would not create a database that is a Snapshot. What I am speaking of here is a property within a Query Object. In Access, Queries are objects within your database. You can create them, name them, and save them. You can adjust the Recordset Type of a named query object while in Design View. You can find the property settings within the Property Sheet.

By default, the Property Sheet is visible while in design view. However, the property sheet will display properties for the currently selected item. The Recordset Type property is associated with the Query, itself. So, you will not see it if a field has focus, for instance. Select the Query and view the Query's properties by clicking empty space within the designer.

If the Property Sheet is not visible, use the Show/Hide group and select Property Sheet. The Show/Hide group is under the Design Tab within the Ribbon.


.