I'm not sure I am following you. Are you trying to connect Access to a pgsql database via the ODBC driver, or are you trying to create an ODBC connection to your existing Access Database? If you are trying to connect Access to a pgsql backend could you list your DSN settings, and the steps you are taking in Access to link to the ODBC tables that lead to the error? Also are you using the ANSI or Unicode driver, and what version of the driver? Is pgsql running on a remote system or on the local system?
David Gardner, IT
The Yucaipa Companies
From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Bernardo Baranek
Sent: Tuesday, June 12, 2007 6:12 AM
Subject: [ODBC] Problems accesing exported MsAccess data
I am migrating an access database (.mdb) to Postgre through the odbc driver.
I could succesfully export the tables. I can read the tables under the pgadminIII
I attached the tables using the same odbc driver to a new Access database but I am unable to open the tables from the Access interface.
Allways I try to open a table a get error 3010 (Microsoft jet) saying table "TMP%#MAU@" already exists.
Can you help me on this matter ?
In response to
pgsql-odbc by date
|Next:||From: David Gardner||Date: 2007-06-12 18:56:09|
|Subject: Perl script to pull SQL statements from CommLog|
|Previous:||From: Bernardo Baranek||Date: 2007-06-12 13:11:35|
|Subject: Problems accesing exported MsAccess data|