I supposed that, but I wanted to be sure.
Thanks very much,
Giovanni
2010/9/15 Mike Toews <mwtoews@gmail.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@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
>>
>
