Re: Problems accesing exported MsAccess data

[BT <bazylt(at)gtut(dot)internetdsl(dot)pl>]

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(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
> *To:* pgsql-odbc(at)postgresql(dot)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
>
>