Access database corruption

Question

Greetings!

I know this is a general question. I have a specific issue where the user of a multi-user application with an Access database has managed to corrupt the db twice in four months.

I used the built in utility to repair it - the error was 'The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time'.

What are the typical reasons for such occurrences?

Any feedback would be appreciated.

Thanks,

Answer 1

First, your database needs to be split as indicated. If it isn't, that is a major source of your problem and splitting will probably alleviate it. 

If it doesn't, then you may need to play with the record locking.

Answer 2

Quickly review http://www.devhut.net/2017/04/09/setting-up-an-ms-access-database/  is this your setup?

Answer 3

Are your users all sharing the same Access database file, or is it split into a front-end and back-end, with each user having their own copy of the front-end?

Answer 4

Thank you Gina, that was helpful

Answer 5

Typical reasons (applies to .accdb's as well)...

http://www.granite.ab.ca/access/corruptmdbs.htm