From: James Miller <bmg_jmiller@yahoo.com>
To: Postgresql Interface List <pgsql-interfaces@hub.org>
Subject: More Access Database Migration Questions
Date: Thu, 29 Apr 1999 15:38:38 -0700 (PDT)
Message-ID: <19990429223838.1540.rocketmail@send101.yahoomail.com> (raw)
I am working on the deployment of a service software package that is
implemented in Access2.0 (I have the Access97 beta and am investigated
it as well) and would like to migrate the database backend out of the
Access db file to Postgres by replacing the local table entries with
references to a System DSN of postgresql connection via WAN. (It's
not an enterprise product but I was of course happily volunteered to
shoehorn it to "web-enable" it...;)
Has anyone implemented a similiar solution across WAN connections? Is
this a viable proposal? Have their been problems with data conflict
resolution? Anyone have ideas for data replication, sync, and
corruption for providing offline support using Access and Postgres
together?
Does Access put any restrictions other than the requirement of a
primary key on each table on ODBC and Postgres? I still have trouble
with the oid problems that have been discussed this week and don't
understand what the problem is... ;<
Thanks for your continued advice.
--
james adot miller anAtsigN BMGSeltec andaDotCom
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: bmg_jmiller@yahoo.com, pgsql-interfaces@hub.org
Subject: Re: More Access Database Migration Questions
In-Reply-To: <19990429223838.1540.rocketmail@send101.yahoomail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox