Nico van der Westhuizen
asked on
X64 ODBC query not working on mapped drives
Using Office 2016 64bit with 64bit ODBC DSN and using a access 2016 database to pull MS queries from text file to excel.
If the query file is stored anywhere on local PC >>>>> it works.
If the query is stored on network location and its accessed via UNC path >>>>> it works.
If the query is stored on network location and its accessed via "Mapped network drive" >>>>> not working.
Error:
The text file specification 'xxx' does not exist.
Error in attached file.
X64-ODBC-query-error.jpg
If the query file is stored anywhere on local PC >>>>> it works.
If the query is stored on network location and its accessed via UNC path >>>>> it works.
If the query is stored on network location and its accessed via "Mapped network drive" >>>>> not working.
Error:
The text file specification 'xxx' does not exist.
Error in attached file.
X64-ODBC-query-error.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have recommended this question be closed as follows:
Accept: pcelba (https:#a42186972)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
MacroShadow
Experts-Exchange Cleanup Volunteer