I have a set of linked Tables.   There are queries written from these tables.  The queries are executed in an order - and - are set-up to reference one another - like an earlier query will generate a temporary table that a later query will next utilize.  All these queries will export both tables & newly created queries into another MS Access Database.

I'm picking up and doing maintenance on someone else's work.  I looked at the VB Code within the modules - and did not find anything wrong.   The ones that are working and the ones that are not working all all coded alike.    I'm just trying to recreate the same scenario with a new database.  The Tables work just fine with Make-Table-Queries.  But,  I'm not able to replicate the Queries outputed to the new database from the Queries that are sitting in the original database.

Please assist with how I may get around this....  Thank you,  Raj.