monheimx9
Member
- Local time
- Today, 08:56
- Joined
- Aug 18, 2022
- Messages
- 31
Well, looks like I'm stuck
I have a Procedure that use a Pass-Through Query to connect to an SQL Server Database, this part works wonderfuly without any issues
But for some reasons, It seems that I simply can't do the same with an Access Backend instead
ODBC Connect Str:
When I try to run that query I get this error:
Context:
This query is part of a process that automatically recreate local tables when I'm updating Views or Stored Procedure on the SQL Backend
In order to succeed I need to use DAO instead of ADO to work with TableDef properly
Since there are tables and queries that I can't move yet that are still on the Access Backend I need to compromise a bit and work with said backend
This backend is accessible on our local network
My question is as follow:
Has anybody been able to run Pass-Through Queries to another Access Database ?
If that's the case, were should I look to try debugging this ?
If that's not the case, I know a workarround, but I want to be sure before I start to refactor some of my code
I have a Procedure that use a Pass-Through Query to connect to an SQL Server Database, this part works wonderfuly without any issues
But for some reasons, It seems that I simply can't do the same with an Access Backend instead
ODBC Connect Str:
ODBC;Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=R:\Business\Gestion\IMEx-DTP_SA_Dorsal.accdb;
When I try to run that query I get this error:
ODBC--connection to '{Microsoft Access Driver (*.mdb, *.accdb)}' failed
Context:
This query is part of a process that automatically recreate local tables when I'm updating Views or Stored Procedure on the SQL Backend
In order to succeed I need to use DAO instead of ADO to work with TableDef properly
Since there are tables and queries that I can't move yet that are still on the Access Backend I need to compromise a bit and work with said backend
This backend is accessible on our local network
My question is as follow:
Has anybody been able to run Pass-Through Queries to another Access Database ?
If that's the case, were should I look to try debugging this ?
If that's not the case, I know a workarround, but I want to be sure before I start to refactor some of my code