how to combine two database - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

how to combine two database

Alexis Cao

4 years ago

i have two database, there are some similar table or requires in them, how can i combine them together or is there better way? thankx

	Alex Hedley @Reply 4 years ago
Copy and paste via the navigation window Export / import Link

	Alexis Cao OP @Reply 4 years ago
is there any way to make the connection for these two bases, Dear Alex

	Alexis Cao OP @Reply 4 years ago
i mean in fact, these two database can be one, but considering the big size so make two

	Scott Axton @Reply 4 years ago
Split Your Database (or link other databases)

	Lyle Bailey @Reply 4 years ago
you can create a query using unions but the down side you cannot edit the combined union. see https://www.youtube.com/watch?v=Y1B2W6VfWaw the best way us using a primarykey like studentno then have one or more table holing info one for studentaddress, studentgrades , etc then create a query using the primarykey to join them, this way you cam edit the info.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View