I have linked 2 text files in an Access 2000 database and now I'm
trying to read these via ADO with SQL queries.
I succeeded in opening one at a time, but not the both !!
My connection string is:
I open a recordset like I do with normal tables.
The following parameters are used: adOpenStatic, adLockPessimistic,
My two SQL queries are simple: "SELECT * FROM LINKED1;" and "SELECT *
The first opens, but when I tries to open a recordset with the second
SQL query AT THE SAME TIME, I catch the following _com_error
"The text file specification 'File2 Link Specification1' does not
exist. You cannot import, export, or link using the specification."
Here File2.txt is the name of the second linked file.
Has someone an explanation (and a solution) ?