Q
quartz
I am using Office 2003 on Win XP.
I am querying Access from Excel. In a test, the following SQL string on
Northwind returns the error: "no read permission on MsysObjects"
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>'~') AND
(Left$([Name],4) <> 'Msys') AND (MSysObjects.Type)=1 ORDER BY
MSysObjects.Name;
Can someone please post example SQL to programmatically grant permissions?
If that is not an option, how can I get this to work? (please post example
SQL). Thanks much in advance.
I am querying Access from Excel. In a test, the following SQL string on
Northwind returns the error: "no read permission on MsysObjects"
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>'~') AND
(Left$([Name],4) <> 'Msys') AND (MSysObjects.Type)=1 ORDER BY
MSysObjects.Name;
Can someone please post example SQL to programmatically grant permissions?
If that is not an option, how can I get this to work? (please post example
SQL). Thanks much in advance.