Re: MDB 2 POSTGRESQL MIGRATION PROBLEM

The field was primary key in my mdb and the type was autonumber.
it is primary key in PostgreSQL as seen above
- Table: Firma
CREATE TABLE "Firma" (
  "SirketKodu" text NOT NULL,
  "SirketAdi" text,
  "Adres1" text,
  "Adres2" text,
  "Adres3" text,
  "Ilçe" text,
  "Il" text,
  "Ülke" text,
  "VergiDveNo" text,
  "BölgeNo" text,
  "MuhasebeKodu" text,
  "Vade" int2,
  "Note" text,
  "EksikBilgi" bool,
  "Lade" float8,
  "SirketKisaAd" text,
  "Eşantiyon" text,
  "Grup" text,
  "TaşKaraIth" bool,
  "TaşKaraIhr" bool,
  "TaşHavaIth" bool,
  "TaşHavaIhr" bool,
  "TaşDenizIth" bool,
  "TaşDenizIhr" bool,
  "TaşDemirIth" bool,
  "TaşDemirIhr" bool,
  "OrgGümrIth" bool,
  "OrgGümIhr" bool,
  "OrgTesvik" bool,
  "Sigorta" bool,
  "e-mail" text,
  "www" text,
  CONSTRAINT "Firma_pkey" PRIMARY KEY ("SirketKodu")
);


the design view in MSAccess for table Firma, field SirketKodu  seems to be a
primary key too.

I ODBC linked it again and it dont ask me if there is a primary key in
MSACCESS.

I am confused !!!
Because other tables works well...

Serkan


-----Original Message-----
From: wsheldah@lexmark.com [mailto:wsheldah@lexmark.com]
Sent: 18 Şubat 2002 Pazartesi 22:33
To: Serkan Bektaş
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] MDB 2 POSTGRESQL MIGRATION PROBLEM




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