I did a cut and paste, but I can not pull all records. I tried to create the union query, no luck. Used select all [ract] union select all [ract1]. Just want to be able to combine the two tables. All field names are the same.
Depending how bad you needed to merge the two data sources and how large are the database, you can write a small vb application which is safer than cut and paste because you know exactly in detail how you want it done in process. You can test on copied database as many times a you want to make sure it's perfectly alright then do it finally.
This is the logic flow I would suggest
Make sure the two tables are not linked with any field
I presumed your term "database" are actually tables with common field names. If they are totally separate database, you need to open two connections, then open each recordset from different connections, otherwise just open two recordset like below..
Ract.open "Select .......
Ract1.open "Select ....
While not Ract.eof
Ract1.field1.value = Ract.field1.value
Ract1.field2.value = Ract.field2.value