On Tue, 2003-11-04 at 12:46, Geoffrey wrote:
> 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?
Um, use both??
We've been having some success using Access front ends with postgresql
back ends. Takes away the data corruption/scalability issues, but keeps
the strength of the Access reporting and data entry interfaces.
--
.Michelle
---------------------------
Michelle Murrain
[EMAIL PROTECTED]
Database Designs Associates, Inc.
Boston 617.889.0929
Amherst 413.253.2874
Cell 413.222.6350
www.dbdes.com
AIM:pearlbear0 ICQ:129250575
"Our capacity to make peace with another person and with the world
depends very much on our capacity to make peace with ourselves." -- Thich Nhat Hanh
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
