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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Geoffrey Sent: Tuesday, November 04, 2003 11:46 AM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] Building secure systems inspite of Microsoft ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
