We have a client/server application with an Access front-end (MDB) and a SQL Server Back-end. We just moved the data to a new SQL Server machine as the old server was failing. Problem is that on client machines who are running Windows 7 the database is EXTREMELY slow. For example, a user selects a record from a list box on a form and then a subform displays with related records. On the XP machine, the refresh is a split second; on the Windows 7 machine, the refresh takes about 1-2 minutes.
This just started happening after we moved the data. Any suggestions?
Oh, and we are using Access 2007 however the file is a MDB