• Back in '90s I developed and maintained FoxPro applications, which was then using the same client / file server model perpetuated by MS Access today. Things like network bandwidth, concurrency, and data corruption were daily (not just occasional) struggles.

    I found a TechRepublic article that summarizes best practices for avoiding MS Access database file corruption.

    #1: Split large databases into separate files

    #2: Store temporary tables in a separate database file

    #3: Don't use memo fields

    #4: Don't store picture files

    #5: Create temporary tables to speed up queries

    #6: Be careful with wireless networks (WiFi)

    #7: Be careful with WAN connections

    #8: Don't put Mac and Windows users on the same network

    #9: Troubleshoot network hardware

    #10: Check the server's configuration

    http://www.techrepublic.com/blog/10-things/10-ways-to-prevent-access-database-corruption/

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho