Linking tables from MS Access 2013 works fine, but cannot get table and column comments

From: Andreas Buschka <a(dot)buschka(at)tarent(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Linking tables from MS Access 2013 works fine, but cannot get table and column comments
Date: 2014-10-17 12:17:46
Message-ID: 9c7c3e5694091bdad73d6db997d419c5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello all,

I am sorry if this question has already been answered, but I could not find
it in either the FAQs or by searching this mailing list.

We currently have the following setup:

- pgsql Server 9.3 running on Windows x64

- pgODBC driver 9.0.3 on Windows x64 clients (using 32-bit version due to
MS Office version)

- Microsoft Access 2010 (2013 on some workstations) with all patches

We have created some tables and commented them, like this:

COMMENT ON TABLE our_table_name

IS 'A comment about this table.';

COMMENT ON COLUMN our_table_name.pk_our_table IS 'A comment about the
primary key column.';

This works fine, I can see the comments in pgAdmin. However, when I link
these tables into a new Microsoft Access database (created a DSN in the
32-bit ODBC admin using default settings), the table and its fields are
linked correctly, however, not a single comment, neither for the table nor
for any column, is imported into Access. This is rather unfortunate,
because our data model is well-documented, and we would like to have this
information available in Access as well.

I tried playing with various settings of the ODBC connection, but none of
them had any effect on the table link. Is importing the comments possible
at all?

All the best,

Andreas

Browse pgsql-odbc by date

  From Date Subject
Next Message Oliver Freyd 2014-10-17 12:49:06 Re: [PATCH] SQLFreeStmt deletes params, but does not reset the stmt->prepared state.
Previous Message Inoue, Hiroshi 2014-10-17 12:08:51 Re: [PATCH] SQLFreeStmt deletes params, but does not reset the stmt->prepared state.