I'm just working on a project which include a form with sub forms.
When I use linked tables to the SQL-Server and the Frontend database is on the same computer as the SQL-Server, form and sub forms moving speed between records is okay.
But if the Frontend database is on another computer as the SQL-Server, form and sub forms moving speed between records is very, very slow.
If I convert the database to an Access Data Project, form and sub forms moving speed between records is okay on both computers.
Any thoughts why it is slow when the Frontend (linked tables) is on another computer, when the speed is okay for an Access Data Project?
It is the same Backend and same Frontend.
I use MS-Access 2010 and MS-SQL Server 2008 Express.
When I use linked tables to the SQL-Server and the Frontend database is on the same computer as the SQL-Server, form and sub forms moving speed between records is okay.
But if the Frontend database is on another computer as the SQL-Server, form and sub forms moving speed between records is very, very slow.
If I convert the database to an Access Data Project, form and sub forms moving speed between records is okay on both computers.
Any thoughts why it is slow when the Frontend (linked tables) is on another computer, when the speed is okay for an Access Data Project?
It is the same Backend and same Frontend.
I use MS-Access 2010 and MS-SQL Server 2008 Express.