Query design on Access/SQL database - TechRepublic
General discussion
January 10, 2002 at 10:56 AM
ajd

Query design on Access/SQL database

by ajd . Updated 24 years, 5 months ago

I have an Access database that has outgrown Access 2000 and needs to be moved to SQL Server. I am going to retain the Access forms I have developed as the front end.

My question is: In order to optimise performance and data integrity, should thedatabase queries be run on the client in the Access 2000 front end, or on the SQL server as Views?

This discussion is locked

All Comments