[Last Call] Learn how to a build a cloud-first strategyRegister Now


Access 2007 database opened in Access 2010 tables are grey.  Can open, but are missing when database is copied

Posted on 2012-09-08
Medium Priority
Last Modified: 2012-09-09
I have an application developed in Access 2007 with a split front/back end.

With Access 2010 out there, we have a few clients who use 2010.  We can open and work with the database in 2010, but the tables are greyed out.  It almost seems like a security rights thing, but we leave these databases wide open.  I've noticed that tables that I've worked with may be black.

When I copy this database from my client's server, to mine, all of the tables are gone, may be just hidden?  The size of the database indicates that the data is actually there, but I can't see the tables.  Help?

I've tried opening it on my end using both Access 2007 and Access 2010 and still can't see the tables.
Question by:wlreimer
LVL 61

Expert Comment

ID: 38380281
It sounds like they are Hidden Tables.

In Access 2007/ 2010:

Options --> Current Database --> Click the Navigation Options button under the Navigation heading.

Check the box labeled "Show Hidden Objects"

That should make them display, greyed out.  At that point you can right click them and hide/unhide them (which with "Show Hidden Objects" checked will make the text display black when unhidden or grey when hidden)
LVL 31

Accepted Solution

Helen Feddema earned 2000 total points
ID: 38380919
There are problems with compatibility between Access 2007 and 2010 databases.  Not all the time, but sometimes, and one of the symptoms is disappearing tables.  See my Access Archon article on this topic:


Author Comment

ID: 38381491
Thanks Helen, I already had hidden objects shown.  This was actually a 2007 database originally.  After reading your article, I created a new 2007 database and imported all of the objects into it and was able to do what I needed to.

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question