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

Posted on 2012-09-08
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

    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

    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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
    In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now