>
>A reply to your post from someone else shared my sentiments...Win95 peer-to-peer is more designed for workgroup type stuff. Common documents and other single, contiguous file-sharing. A database/table is one physical file being shared by multiple people who are writing *portions* of the file.
>
>I have run into monster problems with buffered tables on a peer-to-peer Win95 LAN. Problems I don't run into with WinNT, Novell, et al.
>
>So...it's not a question of questioning what Win95 was designed to do...it's a situation where there *is* a problem and that you have to workaround.
>
>I think there is a KB article on this topic...I'll try to find it and post a followup


Thanks to all for your feedback. The KB article John mentioned indeed indicates that Win95 peer-to-peer has problems with DB applications that use record locking instead of file locking.

To make matters worse our end-user did not have a dedicated file-server but used the one machine both as a workstation and as a file server and print server for the rest of the network. The machine was heavily loaded.

Our client has agreed to introduce a NT server in their network. At the same time we are reviewing our use of Buffered tables and will try to avoid using this feature. We hope both of these changes will fix our data corruption and network problems.

Thanks to all.

regards,

Alain