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