Re: ms-access tables relationships question

Hi Giovanni,

MS Access does not import anything to Relationships. Only the basic
table schema is visible in MS Access, such as ODBC-interpreted data
types and primary key(s) (visible with the key logos in read-only
Design view).

When you link a table into Access, you can only do basic INSERT,
UPDATE, and DELETE operations. If you change your source table schema
(e.g., change a data type, rename/add/delete a column), then you need
to update the linked table using the Linked Table Manager tool. You
can add/edit your Relationships without any modification to the source
database.

-Mike

On 15 September 2010 01:33, G. Allegri <giohappy@gmail.com> wrote:
> I'm new to ODBC world, and I need to use it for an application in MS
> Access where I need to view/manage PG data sources. I've tried to
> google but I haven't been able to find a clear answer to a question:
> can the Access relationship tools visualize the original table
> relationships in PG? I mean, simply, foreign key constraints. If not,
> I can set them up in Access but I suppose they don't affect the PG
> table structures, right?
>
> Thanks for any clarification,
> Giovanni
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>