Why no links creat automatically, when use tools-->relationships?

  • Thread starter Thread starter XS
  • Start date Start date
X

XS

I import 300 tables from a sql database to Access, trying to figure out how
those tables link to each other. I use Tools-->Relationships, try to get
their relations automatically. But it just gives me 300 seperate tables
without any link.

What should I do? Should I figure out those relationship manually? (although
I was asked to do that manually, I can't believe. I think there should be a
method to gernerate the relationships automatically, even "guesses" made by
software would be helpful.)

Thanks to all!
 
Did you import or link the tables?

If you link, the relationships exist in the back end database, not in the
front end.

If you import all tables at once, you get the relationships as well by
default. Perhaps you can delete your tables, and import again. Go to:
File | Get External | Import
Select the database.
In the Import Objects dialog, click the Options button.
The dialog expands downwards.
Make sure Relationships is checked under Import.

This assumes:
a) You are importing from a source where the relationships exist.
b) You are using Access 2003 or earlier. In A2007, import is on the External
Data tab of the ribbon.
 
Thank you Allen,

I am using Access 2007. When I get to "Import Object" there is no "option"
button, I dont know how to select relationship.

I did Link to that database, since it has 600+ tables, and some tables have
100,000 records. Everytime when i try to Import all of them, Access failed(I
think it's crushed.). Do I need to import all tables to get relationship? Can
I just import several main tables, and get relationships between them?

Do you think there is a possibility that the database has no relationship
set up by designer?

Thank you very much!
 
A2007 does import relationships by default, the same as previous versions.

It is possible that the original designer did not use an relationships. If
there's 600+ tables, perhaps he's made a basic error such as using a
different table for each entity (e.g. company)
 
Thanks Allen,

So is there any suggestion in you mind? What can I do? with those
600+tables........

Br,
 
Not sure I understand that question.

If you don't know anything about the tables, what they are, or what
relationships exist, you might not be able to do anything with them.
 
Actually, I really don't know anything about them. I know those tables'
business meaning, but I dont know how they connect to each other. So my boss
asked me to open each of them, read them, and find out how they link to each
other....

I am almost lost in this databsase now....

Thank you, Allen!
 
Do you think I can use VB program to read their relationships?like primary
key for each table?

I think there must be primary key and links seted for each table, otherwise
how could they maintain the database? I think the problem is when i import
tables to Access, Access lost all relationships......

Thanks.
 
XS said:
Do you think I can use VB program to read their
relationships? like primary key for each table?
Click to expand...

Perhaps, but you'd be relying on the developer(s) having used consistent
naming conventions for that to work. The tables themselves do not
inherently contain information about relationships and, believe me, even the
same developer may not have been consistent in naming; if there were, as may
well be the case, multiple developers, the probability of consistent naming
is even more reduced. (These are the same reasons why Access can't
automatically create relationships for you.)

Larry Linson
Microsoft Office Access
 
OK, now I can totally give up getting relationships automatically..... I dont
think they used same name....

Thank you Larry.
 
Back
Top