Accessing a Linked Table with ADO

[JimmyJam]

I am running a query SELECT * FROM data
where data is a linked file in an Access database. I don't want to put the data into a table. I want to leave the data in the file and access it as a linked table.

My Code is

adoRS.open "Select * from data",connection,adopendynamic,adlockreadonly,acmdtext

When I execute this code I get an error message. The recordset opens if I have a linked SQL Table or an Access table. Any other tables such as a paradox or this text file it will not work.

Has anyone tried this


Jimmy

[Clunietp]

remove these lines from your RS.OPEN method and try it:

adopendynamic,adlockreadonly

these can sometimes cause problems