User Updates on Front end database not updating Back End

[birth19]

Hi All,

I have a Database that has been split into two.

Back-end for all the data.

Front end for all the forms and queries.

The front end has been saved in a accde format and distributed to 20+ users. They have all saved this onto there computers and this is used as an application.

The users complete a form on a weekly basis on the application and then save. This then saves into the back end.

For some reason I have noticed that a few users submission randomly do not save. For the life of me I cannot understand why.

All users have saved them into the back end in the past but every now and then submission for users do not save.



Can anybody explain to me why this is happening?

[rpeare]

How many concurrent users do you have and are you using an unbound or a bound form for your data entry?

Access typically does not like more than about 3 - 5 concurrent users (particularly when adding new data) which you can mitigate a little by using an unbound form for data entry.

You could theoretically check to see if the record exists in your dataset before it allows you to navigate away from the form if you're consistently encountering this error.