we have a large ms-access application (as .mde file) which is connected to
an oracle database.
Now we want to migrate to postgresql. Database migration has been done
when starting the access-application we get the following error:
"Cannot find table ... on database"
I manually connected to postgres via access and find out that postgresql
provides every table with the
full qualifier, which means, that while access is looking for a table
(e.g. mytable) postgresql provides only a table ( myschema.mytable ).
Is there a setting which prevent ms-access from for an unqualified name or
the other way around, is there an setting, which disable the
to be shown to access in the case where the tableowner is connected to
thanks in advance
pgsql-general by date
|Next:||From: Sim Zacks||Date: 2004-10-26 11:02:40|
|Subject: Bug: 8.0 beta1 either view optimization or pgdump/pgrestore|
|Previous:||From: Jeff Davis||Date: 2004-10-26 09:55:17|
|Subject: Re: Theory!!|