I would like to know the source of my access table

Hi,

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?

Thanks
woodmacnapsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Paul MacDonaldDirector, Information SystemsCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dale FyeOwner, Developing Solutions LLCCommented:
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:

currentdb.TableDefs("YourTableName").connect

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
Jeffrey CoachmanMIS LiasonCommented:
Dale,

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

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

...Just for my own info...
;-)

Jeff
Dale FyeOwner, Developing Solutions LLCCommented:
Jeff,

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.
Jeffrey CoachmanMIS LiasonCommented:
thanks for the info...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.