Thread: Schema in ODBC table names

Schema in ODBC table names

From

Michael Wyraz

Date:

20 January 2003, 23:33:43

Hi!

since we have upgraded our postgres to version 7.3,
all table names within MS Access have the schema as
prefix.

Is there an option in the odbc driver to disable this?

Thanks a lot.
Michael.

Re: Schema in ODBC table names

From

"Dave Page"

Date:

21 January 2003, 06:32:17


> -----Original Message-----
> From: Michael Wyraz [mailto:michael.wyraz@evermind.de]
> Sent: 13 January 2003 13:53
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] Schema in ODBC table names
>
>
> Hi!
>
> since we have upgraded our postgres to version 7.3,
> all table names within MS Access have the schema as
> prefix.
>
> Is there an option in the odbc driver to disable this?

No. If schema names are available, Access will prepend them. It does it
with SQL Server as well.

Regards, Dave.