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

Re: ms-access tables relationships question

From: "G(dot) Allegri" <giohappy(at)gmail(dot)com>
To: Mike Toews <mwtoews(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ms-access tables relationships question
Date: 2010-09-15 14:48:48
Message-ID: AANLkTinu1kSg88=5CXommN9=MykauoYL_bK-vBdTd65h@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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

pgsql-odbc by date

Next:From: AndreasDate: 2010-09-16 02:59:23
Subject: Re: ms-access tables relationships question
Previous:From: Mike ToewsDate: 2010-09-15 14:23:50
Subject: Re: ms-access tables relationships question

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