Corruption

[Bil]

I am having a shared .mdb file , I always get the message
database need to be repaired or it's not recognized ,
after entering alot of records by three users ,
do anyone have a suggestion please,,,

 

[John Spencer (MVP)]

Are you sharing the entire database?

In this situation, you should have split the database into two parts - a front
end that contains all the forms, modules, reports, and links to the tables in
the backend and a backend that contains only the data (the tables).

If you don't split the database, you will continue to corrupt your database.