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

Re: ms-access tables relationships question

From: Mike Toews <mwtoews(at)gmail(dot)com>
To: "G(dot) Allegri" <giohappy(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ms-access tables relationships question
Date: 2010-09-15 14:23:50
Message-ID: AANLkTinTXeZ6vTWhnCnjj8wn=8hvUbdNvHbJkqP_2Z_1@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>

In response to

Responses

pgsql-odbc by date

Next:From: G. AllegriDate: 2010-09-15 14:48:48
Subject: Re: ms-access tables relationships question
Previous:From: G. AllegriDate: 2010-09-15 08:33:16
Subject: ms-access tables relationships question

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