I would like to know the source of my access table

Posted on 2011-10-06
Last Modified: 2012-05-12

I have an access database with tables created from different data sources like excel spreadsheet  or other access tables. The access database was created sometime back. Now I am trying to find a way to find the source of the tables created in the database. Is there a way to find it?

Question by:woodmacnaps
    LVL 33

    Accepted Solution

    No, I don't think so, if all you have to go on is the tables themselves.  I suppose you could take some unique information from a table and search your network for it, but I wouldn't hold out much hope.
    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    If the data was imported into Access tables, there is no way to determine the source of the data.  If the tables are linked from some other data source, you should be able to determine the source of the data several ways.

    1.  Mouse over the linked table in the database window.

    2.  look at the tables Connect property in the tabledef object:


    3.  Look in the system table (mSysObjects).  Easiest way to do this is in a query:

    SELECT Name, Connect, Database, Type  from mSysObjects
    WHERE Database IS NOT NULL
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    I usually just pull
       WHERE Type=6 (...Linked tables)

    Is: WHERE Database IS NOT NULL
    ...more full proof?

    ...Just for my own info...

    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)

    I used to use Type = 6 (eons ago).

    Then I read something in one of the Access magazines that indicated that there was no guarantee that MS would not change the values or the meanings of the values in the Type column, and it recommended just using the [Database] IS NOT NULL syntax; so I changed.

    I've never had it fail on me, so I've never switched back.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    thanks for the info...

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    745 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

    13 Experts available now in Live!

    Get 1:1 Help Now