On Tue, 9 Dec 2003, Chris Travers wrote: > Case in point: > > MS Access was designed to have multiple database managers manipulating > the files themselves directly and uses another file for locking > information. However-- as anyone who has ever worked with the process > will tell you: Don't do it. Data corruption (often unrecoverable) will > result. > > The lessons we have learned from MS Access are: > 1) Don't have 2 unrelated backends trying to access the same data and > 2) Don't do it across a network. > > IMO, this shows a fundamental design flaw in MS Access at least given > how it is marketed.
That all said, anyone who tells you MS Access is really an RDBMS should lose their job... -- Sam Barnett-Cormack Software Developer | Student of Physics & Maths UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
