Re: synchronizing MS access and postgresql tables - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: synchronizing MS access and postgresql tables
Date
Msg-id 4092836A.5090804@commandprompt.com
Whole thread Raw
In response to synchronizing MS access and postgresql tables  ("Chris Ochs" <chris@paymentonline.com>)
List 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

pgsql-general by date:

Previous
From: Richard Gass
Date:
Subject: Re: TCP only listening on localhost???
Next
From: Michael Meskes
Date:
Subject: Re: synchronizing MS access and postgresql tables