Re: Why no links creat automatically, when use tools-->relationshi
- From: XS <XS@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 17 Jul 2009 06:24:09 -0700
OK, now I can totally give up getting relationships automatically..... I dont
think they used same name....
Thank you Larry.
"Larry Linson" wrote:
"XS" <XS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote.
> Do you think I can use VB program to read their
> relationships? like primary key for each table?
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
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.
"Allen Browne" wrote:
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.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"XS" <XS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ACD0B2E0-F540-43E3-ADFC-2A4A835C91B1@xxxxxxxxxxxxxxxx
Thanks Allen,
So is there any suggestion in you mind? What can I do? with those
600+tables........
Br,
"Allen Browne" wrote:
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)
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"XS" <XS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E244266F-73CE-42E7-A08C-E9C35F0790F6@xxxxxxxxxxxxxxxx
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!
"Allen Browne" wrote:
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.
"XS" <XS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1C327051-CB51-4DFC-8B17-EBEB300CA9D4@xxxxxxxxxxxxxxxx
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!
- References:
- Why no links creat automatically, when use tools-->relationships?
- From: XS
- Re: Why no links creat automatically, when use tools-->relationships?
- From: Allen Browne
- Re: Why no links creat automatically, when use tools-->relationshi
- From: XS
- Re: Why no links creat automatically, when use tools-->relationshi
- From: Allen Browne
- Re: Why no links creat automatically, when use tools-->relationshi
- From: XS
- Re: Why no links creat automatically, when use tools-->relationshi
- From: Allen Browne
- Re: Why no links creat automatically, when use tools-->relationshi
- From: XS
- Re: Why no links creat automatically, when use tools-->relationshi
- From: Larry Linson
- Why no links creat automatically, when use tools-->relationships?
- Prev by Date: How to turn an Access form-based report into a table-based report
- Next by Date: Re: Expression question
- Previous by thread: Re: Why no links creat automatically, when use tools-->relationshi
- Next by thread: Labels
- Index(es):
Relevant Pages
|
