Skip site navigation (1) Skip section navigation (2)

Re: Migration form MSACCESS via ODBC

From: "Ermanno PREDONZAN" <ermanno(dot)predonzan(at)ezit(dot)ts(dot)it>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: Migration form MSACCESS via ODBC
Date: 2003-05-05 17:01:06
Message-ID: 003701c31327$ec6ca020$6b00a8c0@ERMANNO (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
MessageSorry I cannot connect to the website (

Also when installing pgAdmin II as Administrator under Windows 2000 I have the following:

Error 1931
cannot update the system file
because the file is protected by Windows.

And then pgAdmin II works, but the connection is VERY slow especially when
clicking on:



  ----- Original Message ----- 
  From: Dave Page 
  To: Ermanno PREDONZAN ; pgadmin-support(at)postgresql(dot)org 
  Sent: Thursday, April 03, 2003 9:02 PM
  Subject: RE: [pgadmin-support] Migration form MSACCESS via ODBC

    -----Original Message-----
    From: Ermanno PREDONZAN [mailto:ermanno(dot)predonzan(at)ezit(dot)ts(dot)it] 
    Sent: 03 April 2003 18:48
    To: pgadmin-support(at)postgresql(dot)org
    Subject: [pgadmin-support] Migration form MSACCESS via ODBC

    With Yours DataBase Migration Wizard when trasferring 'data/time' values from MSAccess I have always this warning:

    Bad date external representation
    "1999-12-16 00.00.00".

    Why ?

   Because your PostgreSQL installation doesn't understand your local time format. The latest snapshot should fix this, but due to ISP issues you will have difficulty getting to the CVS server where the files are. As a temporary fix, please add the following line to your 'hosts' file:

  Then is you browse to that website (using the name, not the address), in the binaries directory you will find instructions for downloading and installing the latest snapshot. If you have problems, let me know and I'll email it to you tomorrow when I get to the office.

  Regards, Dave.

In response to

pgadmin-support by date

Next:From: Dave PageDate: 2003-05-05 19:33:16
Subject: Re: Migration form MSACCESS via ODBC
Previous:From: Dave PageDate: 2003-05-04 08:35:05
Subject: pgAdmin III - Help Required

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group