When you created the ODBC link, did you tell it which field is the primary
key? It allows you to not specify, but then Access has trouble keeping its
screen in sync with the back end.
Wes Sheldahl
Serkan Bektaş <sbektas@karincaint.com.tr>@postgresql.org on 02/18/2002
01:42:29 PM
Sent by: pgsql-general-owner@postgresql.org
To: <pgsql-general@postgresql.org>
cc:
Subject: [GENERAL] MDB 2 POSTGRESQL MIGRATION PROBLEM
Hi
I migrated MS Access2000 .mdb file to postgreSQL 7.1.3.
I used PGAdminII_1.2.0 and Database Migration Vizard Plug-in.
There seems to be no problem.
For only one table there is a problem that;
*When I use PGAdminII to view the data there is no problem. My data is
there!!
*When I use MSAccess and ODBC link for that table it shows "#DELETED#" for
every field and every record.
Only the last record's first field is true data.
I attached the screenshots in a word document.
I couldn't find what is my wrong.
Can you help me ?
Serkan
(See attached file: SCREENSHOT.doc)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly