Duplicate table structure with different data
Since you have determined that the two database approach is not right for you, you want to merge the two databases. (And I agree for all the little value that is)

(1) One suggestion, the simplest, is to rename one of the tables and make the needed changes to the code to use the proper table instead of the proper database and table.

(2) Another suggestion would be to merge the two tables into a single table. You would need to add a column to differentiate between the "Quotes" rows and the "Jobs" rows.  

Also, you would need to make sure that your primary keys are unique between the two tables. If these rows were generated with Access ascending keys it is likely that you have duplicate keys between the two tables.

If this is the case, you would need to change the Primary Keys in, let us say "Jobs", to avoid any PK conflicts with "Quotes" rows.  Then also change all the referencing tables to have Foreign Key values that reference the new Primary Key values.  

If there are many duplicate tables, then repeat as needed to bring everything into the new united database schema.

This will be a bit of work to set up, but once completed you should not need to think about that any more.