From: | Andreas <maps(dot)on(at)gmx(dot)net> |
---|---|
To: | Greg Cocks <gcocks(at)stoller(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Hoping - is there a 'automagically' way to emulate the PK/FK, etc settings in PostgreSQL in the relationships in Access? |
Date: | 2007-11-29 17:51:30 |
Message-ID: | 474EFC22.7050709@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Greg Cocks schrieb:
> |Joshua D. Drake schrieb:
> |> On Wed, 28 Nov 2007 16:24:54 -0700
> |> "Greg Cocks" <gcocks(at)stoller(dot)com> wrote:
>
> |>> Hoping - is there a 'automagically' way to emulate the PK/FK, etc
> |>> settings in PostgreSQL in the relationships in Access?
>
>
> In my experience, not huge, Access can get a little 'confused' when
> running queries if there is a FK that is not emulated in the
> relationship ERD (sic) in Access...
>
See ... the point is ... you are proposing development for an Access
feature that might use pgodbc but isn't odbc driver functionality at all.
So I may predict that the exitement in this discussion group here will
be somewhat limited.
> Yep, went through and drew them - but worried I missed some AND when I
> change my design I need to remember to propagate those changes 'down the
> line'... (interesting to see how Access handles those multiple links...)
>
It's really rather an Access topic.
Hint: At least Access 2000 keeps such simple links and even real fk
constraints in some cases even when the graph doesn't show them anymore.
It works nicely if you explicitely delete a constraint in the graph.
The irritation starts SOMETIMES when you drop or rename a connected
table or even just change a column name that is part of a constraint.
The next time you open the constraint-graph this constraint might have
disappeared, though you still get the integrity-errors as if the
constraint was still there.
Try to find a tool that migrates real DBs to Access. Well, usually it's
the other way round but maybe you are lucky.
> Shall I come over and unplug your telly? You can miss East Enders one
> weekend?
Never heared of "East Enders" but thanks anyway. ;)
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-11-29 19:28:42 | Re: Hoping - is there a 'automagically' way to emulate thePK /FK, etc settings in PostgreSQL in the relationships in Access? |
Previous Message | Greg Cocks | 2007-11-29 17:11:32 | Re: Hoping - is there a 'automagically' way to emulate the PK/FK, etc settings in PostgreSQL in the relationships in Access? |