Re: Linking Access Query
Yes, query works in access.
Never caught on to ADO; but when I click 'get data' 'from database' 'from access database' then choose the dbase with the query a new window opens up called "navigator". I scroll down to the query I want and the right side shows the column names, but also shows 'this table is empty'
I just looked at several queries in this database, some show data here and some don't.
Not sure why.
Also; i'm not using 'copyfromrecordset' to the best of my knowledge....
If flying were the language of men than soaring would be his poetry.