User Updates on Front end database not updating Back End

[niallmacmillan]

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? :banghead:

 

[BigHappyDaddy]

Could it be that the users fill out the form, but the record is not actually saved. Then the user exits the application and their record is discarded because the record hasn't actually saved? In other words, the record selector still shows a pencil when the user exits the application?

 

[Dezirous]

How the front-end and back-end connected to each other? Either linktable method, DAO or ADO method?

 

[BigHappyDaddy]

Pat - Thanks for correcting me. I was never 100% sure about that situation.