Serkan,
Actually, it sounds like you don't have a primary key set up properly, and
Access can't deal with that. Check to make sure that you do! Just an idea.
You could also try adding a field named "TIMESTAMP" that is a date/time
field.
I believe that might fix the problem too. Access can be funny when
connecting
to remote databases.
- Matthew
-----Original Message-----
From: pgadmin-hackers-owner@postgresql.org
[mailto:pgadmin-hackers-owner@postgresql.org]On Behalf Of Serkan Bekta?
(by way of Jean-Michel POURE <jm.poure@freesurf.fr>)
Sent: Tuesday, February 19, 2002 7:52 AM
To: pgadmin-hackers@postgresql.org
Subject: [pgadmin-hackers] [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
---------------------------(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