Merging Data bases in Access

[Guest]

I have three registration databases. Each record has an id_number.

Each of the three databases have different additional columns.

I want to generate a new table from the the original three.

The most current database is the master for using its id_number records and
I need to get the other tables additional columns into the new database.

I have done a query that accomplishes what I want, but I have been unable to
save it as a new table.

Thank you for your assistance,
Michael

 

[Pat Hartman\(MVP\)]

You can change the query to a make table query and that will create a new
table. If you cannot modify the query, you can create a new query that
selects all the columns of your existing query and make that new query a
make table query.

 

[Guest]

Unfortunately I am receiving an "Invalid arguement." after it spends 20
minutes sorting, which is what I was receiving trying other ways. Either
there is a glitch in the program or their is something about the files that
Access does not like.

 

[Pat Hartman\(MVP\)]

Append each table to the consolidation table one at a time rather than
merging them all together before appending.

 

[Guest]

Pat,

Thank you for your assistance. I have found the problem as the database was
too large to make in the same MDB file. I had to make a new MDB file and
combine the tables with a Make Table query into the new file. It appears
that my table single table is now to large and I will have to invetigate
allowing the MDB file to exceed the current 2.1 GigaBytes.