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 ?

Thanks

Bernardo

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 areyou 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
(310) 228-2855
________________________________
From: pgsql-odbc-owner@postgresql.org [mailtogsql-odbc-owner@postgresql.org] On Behalf Of Bernardo Baranek
Sent: Tuesday, June 12, 2007 6:12 AM
To: pgsql-odbc@postgresql.org
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 ?

Thanks

Bernardo

i've the same problem

> I’m not sure I am following you. Are you trying to connect Access to a
> pgsql database via the ODBC driver,

i'm tying to open the connected table or send the query on connected table

> 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,

DSN connection test passed, settings are default

> 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,

with both drivers

> and what
> version of the driver?

psqlodbc-08_02_0400

version of pg is PostgreSQL 8.2.4 on i686-pc-mingw32

> Is pgsql running on a remote system or on the
> local system?

local system

>
>
>
> ---
>
> David Gardner, IT
>
> The Yucaipa Companies
>
> (310) 228-2855
>
> ------------------------------------------------------------------------
>
> *From:* pgsql-odbc-owner@postgresql.org
> [mailtogsql-odbc-owner@postgresql.org] *On Behalf Of *Bernardo Baranek
> *Sent:* Tuesday, June 12, 2007 6:12 AM
> *To:* pgsql-odbc@postgresql.org
> *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 ?
>
>
>
> Thanks
>
>
>
> Bernardo
>
>
>


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq