-
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
-
remove these lines from your RS.OPEN method and try it:
adopendynamic,adlockreadonly
these can sometimes cause problems
