How do I display MSysObjects?

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
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."
 
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
 
Thanks for the tip. I anticipate supporting hundreds of databses. I don't
want to build/add a query to/in each one.
 
Back
Top