Hi,

It is very interesting topic. In my applications I bring one record at a time, for example customer data for one particular customer. Sometimes I display data in related tables linked by CustomerID. It's not too much records either. The only place (I am aware of) where it's possible to bring a lot of records from backend is search screen. For example: search by Name.

>Here is another one of my client-server questions, important to me because I want to open my data across a WAN, and keep the data in Access 97 while letting users of our newer workstations have an Access 2002 front end (which slows things down even more).
>
>I always hear that in client-server environments, you aren't supposed to bring more than 50 or 100 records over at a time. If a user sets filter conditions in a form that end up bringing many more than that, how can you let him have the first 50, and then give him the next 50 when he asks for it? The "TOP values" clause of a query can only give you the first 50, not the next 50. Is there any way to do it if your back end data is still in Access? Our tables have only a few thousand records and a few users, so it isn't worth getting a real database server.