How do I display MSysObjects?

G

Guest

In Access 2000, I use the MSysObjects table to find, modify and refresh
connections to ODBC tables.

Where is MSysObjects in Access 2007?
 
A

Allen Browne

It's still there.

Try creating a query by typing into SQL View:
SELECT MSysObjects.* FROM MSysObjects;

You can set the Nav Pane to show hidden/system objects.
 
G

Guest

Thanks for your prompt reply.

I know how to query the table.

I want to open the MSysObject as a table.

Access 2000 Options menu has radio buttons to display hidden tables and
system objects.

Where's those options in A2007? I can't find them in A2007 "Access Options."
 
A

Allen Browne

Right-click the top of the nav pane, and choose Options.

Or, Click the Microsoft Office Button (top left). Then:
Access Options | Current Database | Navigation Options
 
G

Guest

Thanks for the tip. I anticipate supporting hundreds of databses. I don't
want to build/add a query to/in each one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top