Problems accesing exported MsAccess data

This is a multi-part message in MIME format.

------=_NextPart_000_00F6_01C7ACDA.0E99FFD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=20
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

------=_NextPart_000_00F6_01C7ACDA.0E99FFD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">

Re: Problems accesing exported MsAccess data

--_000_C975BFE03CC5DE4999143A5BEA9FB515021E46B3F1yucexlaxyuc wi_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I'm not sure I am following you. Are you trying to connect Access to a pgsq=
l database via the ODBC driver, or are you trying to create an ODBC connect=
ion to your existing Access Database? If you are trying to connect Access t=
o a pgsql backend could you list your DSN settings, and the steps you are t=
aking 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 p=
gsql 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 [mailto:pgsql-odbc-owner@postgresql.o=
rg] 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 pgad=
minIII
I attached the tables using the same odbc driver to a new Access database b=
ut 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


--_000_C975BFE03CC5DE4999143A5BEA9FB515021E46B3F1yucexlaxyuc wi_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" xmlns=3D"http://ww=
w.w3.org/TR/REC-html40">


>

namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"Person=
Name"/>

Re: Problems accesing exported MsAccess data

i've the same problem

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

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

> or are you trying to create an ODBC=20
> connection to your existing Access Database? If you are trying to=20
> connect Access to a pgsql backend could you list your DSN settings,

DSN connection test passed, settings are default

> and=20
> the steps you are taking in Access to link to the ODBC tables that lead=
=20
> to the error? Also are you using the ANSI or Unicode driver,

with both drivers

> and what=20
> 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=20
> local system?

local system

>=20
> =20
>=20
> ---
>=20
> David Gardner, IT
>=20
> The Yucaipa Companies
>=20
> (310) 228-2855
>=20
> ------------------------------------------------------------ -----------=
-
>=20
> *From:* pgsql-odbc-owner@postgresql.org=20
> [mailto:pgsql-odbc-owner@postgresql.org] *On Behalf Of *Bernardo Barane=
k
> *Sent:* Tuesday, June 12, 2007 6:12 AM
> *To:* pgsql-odbc@postgresql.org
> *Subject:* [ODBC] Problems accesing exported MsAccess data
>=20
> =20
>=20
> I am migrating an access database (.mdb) to Postgre through the odbc dr=
iver.
>=20
> I could succesfully export the tables. I can read the tables under the=20
> pgadminIII=20
>=20
> I attached the tables using the same odbc driver to a new Access=20
> database but I am unable to open the tables from the Access interface.
>=20
> Allways I try to open a table a get error 3010 (Microsoft jet) saying=20
> table "TMP%#MAU@" already exists.
>=20
> Can you help me on this matter ?
>=20
> =20
>=20
> Thanks
>=20
> =20
>=20
> Bernardo
>=20
> =20
>=20


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

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