Importing Relationships

[sloney]

Hello,

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!

Sloney

[sloney]

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????

Thanks,

Sloney

[NeoPa]

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.

[sloney]

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!

Sloney

[NeoPa]

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).