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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Serkan Bekta? (by way of Jean-Michel POURE <[EMAIL PROTECTED]>) Sent: Tuesday, February 19, 2002 7:52 AM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
