I have been working on an in-house software package for over 3 years now.
I started out using an Access database but once we put more users on it
the database began corrupting frequently. We replaced hardware and the
problem would go away for a bit but would soon return. We switched to
SQL Server (using the eval) but we decided to try switching to PostgreSQL
before the 120 eval was up. We're still working on the MSSQL -> PostgreSQL
switch but once we got off of Access everything went good - no more
corruptions :)
David Green
Sage Automation, Inc.
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Geoffrey
Sent: Tuesday, November 04, 2003 11:46 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Microsoft access verses postgresql
I've got a client who is following my suggestion that they replace a set
of excel spreadsheets with a database solution. They are looking at two
proposals, postgresql solution or an Access solution. The requirements
will include vpn connectivity from one site to another. It appears they
will be going with the Access solution. I've got concerns regarding
this based on research I've done that seems to indicate that Access,
when used in a multi-user solution is easily corrupted. Does anyone
have any knowledge/experience with such issues?
--
Until later, Geoffrey esoteric@3times25.net
Building secure systems inspite of Microsoft
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org