Re: [ODBC] Hoping - is there a 'automagically' way to emulate the PK/FK, etc settings in PostgreSQL in the relationships in Access?

From: Andreas <maps.on(at)gmx.net>
Date: Thu Nov 29 2007 - 12:51:30 EST

Greg Cocks schrieb:
> |Joshua D. Drake schrieb:
> |> On Wed, 28 Nov 2007 16:24:54 -0700
> |> "Greg Cocks" <gcocks@stoller.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. ;)

---------------------------(end of broadcast)---------------------------

TIP 6: explain analyze is your friend Received on Thu Nov 29 12:52:36 2007