Active & Archive Tables Identical but Different?

[Instructor Support]

I have two tables and a query that I'm working with in this problem... I'll use names that are meaningful to help explain my issue here.


tblActiveJobs
tblArchivedJobs
qryAllJobsOld&New

So I recently was asked to add several pieces of data to the tblActiveJobs table. Which I carefully documented every change and made sure to reflect those changes in the tblArchivedJobs table so that they could still be in sync. I have carefully checked every field for character accuracy and properties differences. Even to the point of copying each field name into excel and asking it to tell me if the fields are different somehow, in case I can't see one of my own typos.

Unfortunately, opening the qry (a union query selecting all fields via wildcard) gives me a message that I believe tells me that the two tables are too different.

Is there some way in VBA or a tool built in to the system (I'm not allowed to buy additional software to do this) that can tell me what it thinks is different about the design of these two tables?

Thank you for your help.

[Instructor Support]

My mistake, too many fields- not differences. Nevermind!