Try repairing your database with Microsoft's JetComp utility, available at http://support.microsoft.com/default...b;en-us;295334
To stop the corruption re-occurring, you should :
1. Keep the number of concurrent users to an absolute minimum at all times. Write some code to log users out automatically after x minutes of inactivity. There are code samples on the net that will help you achieve this.
2. Compact the database at the beginning of each day. VERY important.
3. Do not use Linked or Embedded OLE objects in your database if you don't have to.
4. Eliminate photos and other images if you are using them on forms
5. Re-examine your data normalisation and see if you can make the data structure more efficient and simpler. Keep the number of tables to an absolute minimum. Keep the number of data writes to an absolute minimum.
6. Write some code that will archive "dead" data at regular intervals
7. Never, ever use database replication. In Access it's appalling and ALWAYS ends up corrupting data (well, in my long experience anyway...and I should point out that this includes databases that I have not written!! )
...and so on. Hope this has helped.
Elmhurst Solutions Limited
Database Development and Consultancy