Yes. Make ALL of your views parameterized views and open them with NODATAONLOAD.

Collect information from the user about what records they'd like to work with, set the parameter variables, and REQUERY().

When you're dealing with remote data, you want to bring over the smallest number of records at a time. The entire app needs to be designed around this philosophy.

Dan


>I am connecting to an Access Database using an ODBC connection and remote views. The trouble is everytime the application starts up it counts through all 500,000 reconrds of the access table before anything can be done. This takes quite a while. Is there a quicker way of doing this?
>
>Thanks
>Ed