Skip site navigation (1) Skip section navigation (2)

Re: Problems accesing exported MsAccess data

From: BT <bazylt(at)gtut(dot)internetdsl(dot)pl>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Problems accesing exported MsAccess data
Date: 2007-08-10 09:31:32
Message-ID: 46BC3074.6000109@gtut.internetdsl.pl (view raw or flat)
Thread:
Lists: pgsql-odbc
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
> 
>  
> 


In response to

pgsql-odbc by date

Next:From: lothar.behrens@lollisoft.deDate: 2007-08-10 16:18:51
Subject: Re: UPDATE with data at exec and CURRENT OF question
Previous:From: Hiroshi SaitoDate: 2007-08-10 06:05:40
Subject: Re: 32 bit ODBC driver for PostgreSQl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group