Access Conversion

From: Mark Lubratt <mark(dot)lubratt(at)indeq(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Access Conversion
Date: 2004-04-10 19:13:04
Message-ID: 17C564D0-8B23-11D8-A1F1-000A9579AF50@indeq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm trying to convert an Access application to have its backend be
PostgreSQL. I've created the schema and imported the data without a
problem.

My problem is that the Access application wasn't written by me and has
numerous queries and table relationships that I want to replace in
place with tables linked to the new backend.

So, far, I've tried adding all the PostgreSQL tables as linked tables.
Then I'm renaming the new linked table over the top of the original
Access table. Access asks me if I want to replace the old table and I
say - yes. This seems to keep the queries in tact. However, if the
table being replace has table relationships defined, then Access wants
to delete those relationships prior to copying over the table.

Is there a way to do this "in place"? In other words, is there a way
to get Access to accept the new linked tables as the old tables without
having to destroy/recreate the table relationships?

Thanks!
Mark

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2004-04-10 20:44:25 Re: COPY TO order
Previous Message Bruce Momjian 2004-04-10 18:36:55 Re: help needed regarding Query processing in postgres