Has anyone encountered any problems in running Access databases stored on a Linux server?
A client of mine has an Access database (split into two files for frontend and backend) that is stored on a Linux server and has about 10-15 users accessing it via the LAN. The database seems to get corrupted or needs repairing very often (sometimes on a daily basis!). I have noticed that the size of the backend data file increases from 4MB to 6MB in a matter of 1-2 hours, even though only existing records are edited and no new records are added. When a compact and repair is carried out, the data file goes back down to 4MB.
Any help/advice appreciated. TIA.
Al
A client of mine has an Access database (split into two files for frontend and backend) that is stored on a Linux server and has about 10-15 users accessing it via the LAN. The database seems to get corrupted or needs repairing very often (sometimes on a daily basis!). I have noticed that the size of the backend data file increases from 4MB to 6MB in a matter of 1-2 hours, even though only existing records are edited and no new records are added. When a compact and repair is carried out, the data file goes back down to 4MB.
Any help/advice appreciated. TIA.
Al