Relationships and Importing

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I'm trying to get information from a database that has
relationships.

I can import the data, and maintain the relationships, by
pressing Right Click in the database window, selecting
Import, chosing my database and checking "Relationships"
under Import.

Is there anyway to do this programmatically?

Thanks.
 
Don said:
I'm trying to get information from a database that has
relationships.

I can import the data, and maintain the relationships, by
pressing Right Click in the database window, selecting
Import, chosing my database and checking "Relationships"
under Import.

Is there anyway to do this programmatically?
Click to expand...

Sure. Check out DAO's CreateRelation() method.

Loop through the Relations collection saving the information
needed to re-create them with CreateRelation().
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

table relationship messing up my link 11
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Stephen Lebans Tools Compatability 6
Programmatically listing Relationships of ADP file 3
Import data according to table relatioship order 8
Easy Steps to Import PST Files to Office 365 0
How to Get Copied Database to Work 2
Using Sysrel90 to restore relationships 5

Back
Top