I am trying to get a list of tables from Access in an Excel VBA program that
I'm writing. I have the query set up in Access that specifies this statement:
SELECT msysobjects.Name, msysobjects.Type
FROM msysobjects
WHERE (((msysobjects.Name) Not Like 'msys*') AND ((msysobjects.Type)=1 Or
(msysobjects.Type)=6));
It works from within Access, but when I ask Excel to use ADO and run "Select
* from [<Name of Query]", I get an access denied error message. The
connection is using the "Admin" user information, and yet I get the access
denied message. I need to know if there is something within ADO that is
blocking the connection or is it a limited amount of access to the
MSysobjects outside of the Access program, and if possible a way to correct
the problem.