The SQL DB is populated through the Main Application-front end in Access but connected to the SQL DB.

The Access Reporting/Applications use:

--SQL Tables

--Access tables that are from other Access DB's (used within other access reporting application)

--Local access tables initially populated from the SQL DB (this is where I am stuck and trying to figure out how these are populated.)

I need to find the connection mapping SQL table/column to Access table/column or find the Queries used to populate the data from SQL to Access.

------------------------------------------------------------------------------

I can see which tables are directly connect to the SQL DB but most of the "Reports" use the Access tables that I am not sure how are initially populated.

I can see which tables are from other Access DBs

I can see which are local Access tables