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

Re: Problems accesing exported MsAccess data

From: David Gardner <David(dot)Gardner(at)yucaipaco(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Problems accesing exported MsAccess data
Date: 2007-06-12 15:55:19
Message-ID: C975BFE03CC5DE4999143A5BEA9FB515021E46B3F1@yucex.lax.yucwin (view raw or flat)
Thread:
Lists: pgsql-odbc
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
(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

Responses

pgsql-odbc by date

Next:From: David GardnerDate: 2007-06-12 18:56:09
Subject: Perl script to pull SQL statements from CommLog
Previous:From: Bernardo BaranekDate: 2007-06-12 13:11:35
Subject: Problems accesing exported MsAccess data

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