My company has developed an Access Database that is on our network so that all employees can look into it and find something.  There are multiple columns.

Unfortunately, due to short cuts being created incorrectly, there are multiple databases with updated information that need to be put into the master.  All that I want to achieve is to move the "add on" data bases into the master so that it's on the network.  How do I do that?

Thanks for the help~

Sbowers

• Edited by sbowers 11 hours 0 minutes ago

Hi sbowers,

Based on your description, my understanding is you want to combine multiple tables in Access.

You can create an append query to get your result. An append query can make it quicker for you to add new records to an existing table. The append query works by selecting records from one or more data sources and copying them to an existing table.

About how to create an append query please refer to this article:

https://support.office.com/en-US/article/Use-an-append-query-to-add-records-to-a-table-F9523FF0-98B2-4C62-A02F-1A32F5A9572C

And you can also watch this video:

https://www.youtube.com/watch?v=f129GBkSQEA

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

Hope it's helpful.

Regards,

Emi Zhang
TechNet Community Su