Dear Friends,
I have linked tables from SQL server and adjusted all queries based on new linked tables' names in my MS Access and tested it. İt workes a little slow in compared to compact MS Access (When the table is also from Access itself). Forms and reports are opening a bit more slowly. But it is not that bad. However I would expect it will be not worse than MS Access itself. Is there a way to accelerate the speed of forms openings? Can it be possible that I did something not very accurate?
(Some additional informations - My linked table connection is done with SQL Server Driver and File DSN
I did all indexing PKs, and also relations in SQL Server side)
Second and bigger problem: My excel export macros in MS Access that are using queries are now failed. I looked at the used queries within my macros. Those queries are working as expected properly by alone. But when it comes to click the export button in my forms which is running those queries are failing.
What is the solution here? I will be apprecitated.
I have linked tables from SQL server and adjusted all queries based on new linked tables' names in my MS Access and tested it. İt workes a little slow in compared to compact MS Access (When the table is also from Access itself). Forms and reports are opening a bit more slowly. But it is not that bad. However I would expect it will be not worse than MS Access itself. Is there a way to accelerate the speed of forms openings? Can it be possible that I did something not very accurate?
(Some additional informations - My linked table connection is done with SQL Server Driver and File DSN
I did all indexing PKs, and also relations in SQL Server side)
Second and bigger problem: My excel export macros in MS Access that are using queries are now failed. I looked at the used queries within my macros. Those queries are working as expected properly by alone. But when it comes to click the export button in my forms which is running those queries are failing.
What is the solution here? I will be apprecitated.