Thats wierd... Hours is a query in my access db not a table.... when I subsitute a table for the query name it works fine so I am not sure what the deal is. Here is the exact code that I am using.... It is vba behind an excel sheet, pointing to an mdb...
Dim db, rs
Set db = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
Did you say it worked with a table name but not a query name?
Are the tables linked or are they in the database with the query?
I do not know if it has any bearing but I'm using Excel/Access 97
But it still works on Excel 2000 and the Access 97 Database
I feel sure that using a System DSN (or File DSN if shared used by others on the same network) setup in then Control Panel to connect to the DB might solve the problem. If it does not then it beats me for now (more time required must get some work done!).