Hi, I'm having trouble linking two access databases together at work. The access database I use at work is linked to another database my manager created. His database is used to populate certain fields add tables the database I use. However he has made a new database and the database I'm using needs to be unlinked from the old database to the new one. How would I go about doing this? Also, since these tables that are being imported from my manager's database would I have to recreate all the relationships between the tables? Would I be able to transfer over the relationships if the tables that from the new database are the same as the old database?
Thanks