This is a split database, with the backend stored on a LAN and the front end on each user’s machine. Sometimes the users access the database from home, over VPN. And did in the case outlined below. I’ve tried to discourage them from doing so, but...
I have a continuous subform bound to a query. The users enter data on the form via combobox, there is one field per record on the form. I'm hearing from certain users that they have entered data in all the fields in the form and it looks to them like all the data is there, but when I look in the table later only some of the records have data, always the first few records.
My question is, is this possible? I can’t think of a reason why this would happen. If they select a value from the combo box and move to the next record, Access would write the data to the table immediately, right? Wouldn’t it show an error if it was unable to write the data? I don’t have any error handling on the form that would prevent them from seeing an error. And they would get an error if the front end loses connection to the back end. So according to the users the form just stops writing the data part way through the form, but they have no indication of that on their end.
I have so far been unable to reproduce this issue. Any suggestions on troubleshooting this?
I have a continuous subform bound to a query. The users enter data on the form via combobox, there is one field per record on the form. I'm hearing from certain users that they have entered data in all the fields in the form and it looks to them like all the data is there, but when I look in the table later only some of the records have data, always the first few records.
My question is, is this possible? I can’t think of a reason why this would happen. If they select a value from the combo box and move to the next record, Access would write the data to the table immediately, right? Wouldn’t it show an error if it was unable to write the data? I don’t have any error handling on the form that would prevent them from seeing an error. And they would get an error if the front end loses connection to the back end. So according to the users the form just stops writing the data part way through the form, but they have no indication of that on their end.
I have so far been unable to reproduce this issue. Any suggestions on troubleshooting this?