thebellguy
New member
- Local time
- Today, 11:38
- Joined
- May 9, 2012
- Messages
- 6
Hi,
I am re-doing an Access 2007 database and I need to find files that are pulling data from it. How do I explain this.
The people that designed this system connect excel files and other access dbs to the tables in this access db and use these in pivot tables/charts etc. When I recreate the database, the structure will change and therefore the tables they link to will not have information in the same format. The table names will be changing too.
I am hoping there is a way to find out which files (and possibly AD user info) have an external link to a table in access. Is there a system table that shows all connections made to the db? I apologize if this is confusing, but the whole set up is confusing and there's no documentation.
Thanks in advance.
I am re-doing an Access 2007 database and I need to find files that are pulling data from it. How do I explain this.
The people that designed this system connect excel files and other access dbs to the tables in this access db and use these in pivot tables/charts etc. When I recreate the database, the structure will change and therefore the tables they link to will not have information in the same format. The table names will be changing too.
I am hoping there is a way to find out which files (and possibly AD user info) have an external link to a table in access. Is there a system table that shows all connections made to the db? I apologize if this is confusing, but the whole set up is confusing and there's no documentation.
Thanks in advance.