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?