Re: synchronizing MS access and postgresql tables

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Chris Ochs <chris(at)paymentonline(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: synchronizing MS access and postgresql tables
Date: 2004-04-30 16:48:42
Message-ID: 4092836A.5090804@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

>
> I was also thinking of using the MS access forms with access tables that are
> just odbc links to the postgresql database. Does anyone know off hand if
> changing the MS access tables from a native table to a linked table would
> require changes in the forms (not counting having to tweak/change data
> types) ?

This does work, we have done it. However you will want to over time move
a lot of the stored queries etc... to PostgreSQL versus Access for
performance reasons.

Sincerely,

Joshua D. Drake

>
> Chris
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.669 / Virus Database: 431 - Release Date: 4/28/2004
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Meskes 2004-04-30 16:59:06 Re: synchronizing MS access and postgresql tables
Previous Message Chris Gamache 2004-04-30 16:35:39 Foreign Key ON DELETE CASCADE Performance