Re: pgaccess/msaccess - Mailing list pgsql-novice

From Josh Berkus
Subject Re: pgaccess/msaccess
Date
Msg-id web-494191@davinci.ethosmedia.com
Whole thread Raw
In response to pgaccess/msaccess  ("G.LeeJ" <G.LeeJ@imyourhandiman.com>)
List pgsql-novice
Lee,

> I know pgaccess is one of the nicest interfaces? for those converting
> over from say
> msaccess use but are there utilities that will convert? a msaccess
> database for use
> in pgaccess..if not is it much of a chore to do so....

PgAccess's interface building tools are not complete at this time, nor
are likely to be anytime soon that I know of.

Further, it's pretty much impossible to convert an MSAccess interace
directly into anything else.  Database Creations makes a tool that
converts MSAccess to Visual Basic, but not even that works 100% of the
the time.

The reccomended course of action, if you have an established MS Access
application, is to convert your data to a PostgreSQL database, and keep
your forms and interface code in MS Access, accessing PostgreSQL via
ODBC.

-Josh Berkus



______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Installing PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: Too much postmaster prozesses / CPU near 100%