Hi,

I'm trying to connect to a txt file, with an ODBC connection. I used the
Microsoft text driver. When I open my recordset with the DSN... I get this
error:


Execution error '-2147467259 (80004005)' [Microsoft][ODBC text driver] The
jet database engine can't open the file '(unknown)'. It can be already open
in exclusive mode or you don't have the rights access to see this data.

My text file is not open when I open the recordset.

Here is my query :

rsDnamae.Open "select * from Dnamae", "DSN=Dnamae"

I hope I will receive answer soon!

Tanx in advance!

Pascal;