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. Don't try to do the same with PostgreSQL. Best Wishes, Chris Travers ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
