Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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.  ;)



In response to

pgsql-odbc by date

Next:From: Dave PageDate: 2007-11-29 19:28:42
Subject: Re: Hoping - is there a 'automagically' way to emulate thePK /FK, etc settings in PostgreSQL in the relationships in Access?
Previous:From: Greg CocksDate: 2007-11-29 17:11:32
Subject: Re: Hoping - is there a 'automagically' way to emulate the PK/FK, etc settings in PostgreSQL in the relationships in Access?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group