By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,387 Members | 1,709 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,387 IT Pros & Developers. It's quick & easy.

Importing Relationships

P: 8

I have approximately 20 mdb's that have the same schema but all have different data for different geographic locations. There are a plethora of tables and relationships (to be built). I want to build relationships so that I can run update queries using referential integrity. It is very time consuming to create relationships and I want to do it for one mdb and copy the relationships over to the other mdbs. Is there a way to do this? I saw a previous post that opted to use the file-->get external data-->import-->select mdb-->options-->check relationships-->definition only-->OK. This doesn't seem to work for me. I open relationships and rt click show all and nothing shows up. What gives? Thanks in advance for any insight!

Aug 29 '08 #1
Share this Question
Share on Google+
4 Replies

P: 8
To add to this I just found that when importing the relationships I had to select the tables that were included in the relationships. Then I selected to just import the definitions only and not the data. The problem is that the mdb that I am importing the relationships into have these same tables already. Therefore, it imports the blank tables associated with the relationships and adds a 1 to the end of the name to denote another table. Ideas????


Aug 29 '08 #2

Expert Mod 15k+
P: 31,662
I just tried that and I found it did the same for me. I'm running A2003 on XP SP2.

I would consider making a backup of the database (Copy the .MDB file) and simply clearing all the data from all of the tables (easily done with a small bit of VBA code).

When all done Compact & Repair the result and you have a dummy empty database.
Aug 29 '08 #3

P: 8
Thanks for your response. These DBs are somewhat large. Lets suppose that I create a dummy DB with all the desired relationships, etc. Is there any easy way to import data from a fully populated DB to the dummy? There are probably 100 spatial tables, 100 lookup tables, and associated Domain tables. Just curious. Thanks a mil!

Aug 30 '08 #4

Expert Mod 15k+
P: 31,662
Well, you could always leave them in the dummy if they are common to all databases, but if not, then yes.
  • You can import tables.
  • You can copy/paste from one database into another with the option of pasting just the data.
  • You can link the remote tables and transfer the data with a query (Or Copy/Paste again even).
Aug 30 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.