Trying to query the MSysObjects object per your example below generates
this
error for me:
Error: ACCESS:-1907[Microsoft][ODBC Microsoft Access Driver] Record(s)
cannot be read; no read permission on 'MSysObjects'.
Here's my connect string (using SQLTalk and an ODBC connection)
connect scheduler admin/; [in dev, no password yet]
I've looked through Access 2003 Tools, Database and Security menus but
can't
see where I (as admin) can let myself get access to the system tables.
Like
the previous writer, I'd like access to system tables for name, column,
type,
length info. for my database. Thanks for any help!
Best Regards - Jeff
Douglas J. Steele said:
SELECT MSysObjects.Name
FROM MSysObjects
IN 'D:\Data\External.mdb'
WHERE MSysObjects.Name Not Like "msys*"
AND MSysObjects.Type In (1,4,6)
ORDER BY MSysObjects.Name