Re: ms-access tables relationships question

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: "G(dot) Allegri" <giohappy(at)gmail(dot)com>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: ms-access tables relationships question
Date: 2010-09-16 02:59:23
Message-ID: 4C91880B.8050309@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,
do you know that there are 2 types of relationships in Access?
Access can only manage strict relational integrity of tables within the
same Access-File.
Even there enforcement is optional. You can draw nice lines between
tables that are still only hints for the query design tool, so it
connects certain columns which you had linked before.
Access generally can't enforce integrity when a table in DB1 is linked
to a table in DB2.

Though integrity gets watched if you import tables from another file
when the integrity relations are defined between tables in the remote file.

When your tables are managed by postgresql and have relations then
postgresql keeps the integrity.
You don't have to bother about it in Access.

Am 15.09.2010 16:48, schrieb G. Allegri:
> I supposed that, but I wanted to be sure.
> Thanks very much,
> Giovanni
>
> 2010/9/15 Mike Toews<mwtoews(at)gmail(dot)com>:
>> 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

Browse pgsql-odbc by date

  From Date Subject
Next Message G. Allegri 2010-09-16 07:47:20 Re: ms-access tables relationships question
Previous Message G. Allegri 2010-09-15 14:48:48 Re: ms-access tables relationships question