Hi dears Experts!
I need your help please...
I've access 2013..which is connected to Sql 2008 via ODBC...
Before I was using query for forms to filter required data...
But after migrating tables from access to sql query takes much longer time to display in forms....
And every time I need to put credentials for sql to connect...
I want to use ADO connection with sql and call the query from sql to lower the latency rate....
Or if any other solution to use or filter records in forms with faster speed...
Server is far away from front end access...
I'm unfamiliar with ADO even I get the syntax for ADO connection with Vba but I don't know where to use and how to call the query or use recordset....
Please guide me....
Thanks
I need your help please...
I've access 2013..which is connected to Sql 2008 via ODBC...
Before I was using query for forms to filter required data...
But after migrating tables from access to sql query takes much longer time to display in forms....
And every time I need to put credentials for sql to connect...
I want to use ADO connection with sql and call the query from sql to lower the latency rate....
Or if any other solution to use or filter records in forms with faster speed...
Server is far away from front end access...
I'm unfamiliar with ADO even I get the syntax for ADO connection with Vba but I don't know where to use and how to call the query or use recordset....
Please guide me....
Thanks