Hello guys again.
I'm user Access as you know.
All my apps was splitting with Access 2k7 backend in localy server as remote folder and also Access 2k7 all things as client.
Now have users who want connect via internet to database with vpn.
I has migration mdb server database in MsSQL. All ok.
Also make new client with ODBC in server ok.
With a normal data 100.000 records new app with ODBC link tables is very very slow compare old way (external data, link tables in access)
What is better settings should I make to the Windows server to MsSQLexpress?
What code need to client side to relink to have better speed than now?
SERVER. Windows Server 2012 MsSQL 2017express
CLIENT Windows 2010 8Gram 8cores, Access 2013
Will make difficult for me to transform all that in PHP etc WEB way....