Not only will you have performance and corruption issues, you'll also have problems with the lock file. And security is a pain to manage. We have replaced all of our multi-user Access databases with PostgreSQL.
Chuck > -----Original Message----- > From: Geoffrey [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 04, 2003 10: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 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
