Search results

Hi Harry, I am working along the same path as you. Improving the performance of Access 03 queries but moving the processing to the back end DB. Have you tried saving the authentication information within the ODBC connection string when you create the PTQ? Essentially when you have the PTQ...

Hello, I have an Access 03 front end with linked tables via ODBC to SQL Server 2000. My objective is to have the processsing for my INSERT/UPDATE queries occur on the SQL Server side and not access, since performance is better this way. The INSERT/UPDATE queries are wrapped in Pass-Through...

Hi Everyone, long time reader first time user :D. Hopefully I can find some anwers.