I posted a similar question yesterday and got no assistance. I've done some more testing now, so I have more information. I hope I can explain the problem well.
I have a form with text boxes bound to a table. When a user changes a value in a text box, closes the form, then reopens the form to that record, the new value has been stored. However, if the user continues to change a value, close the form, and reopen it, at some point, the new value stops being saved. It's almost like the database gets "tired". At first I thought it was only not saving when more than one user is in the database, but I have found that that isn't true. I also thought that it only stopped saving when the database is on the network, but I found that that isn't true either. I put the database on my hard drive, and it will still stop saving. I have tried everything I can think of to fix this problem. I've tried splitting the database. I've tried shortening the Refresh Interval and ODBC Refresh Interval under Options. I've tried "Edited Record" and "No Locks" under the form's Record Locks property. This is only one form of many, and it is bound to one table of many, but the problem happens even when only the one form is open.
Any assistance anyone could give would be greatly appreciated! I am at a loss for what to do, and my coworkers and I can't do our jobs without this database.
I have a form with text boxes bound to a table. When a user changes a value in a text box, closes the form, then reopens the form to that record, the new value has been stored. However, if the user continues to change a value, close the form, and reopen it, at some point, the new value stops being saved. It's almost like the database gets "tired". At first I thought it was only not saving when more than one user is in the database, but I have found that that isn't true. I also thought that it only stopped saving when the database is on the network, but I found that that isn't true either. I put the database on my hard drive, and it will still stop saving. I have tried everything I can think of to fix this problem. I've tried splitting the database. I've tried shortening the Refresh Interval and ODBC Refresh Interval under Options. I've tried "Edited Record" and "No Locks" under the form's Record Locks property. This is only one form of many, and it is bound to one table of many, but the problem happens even when only the one form is open.
Any assistance anyone could give would be greatly appreciated! I am at a loss for what to do, and my coworkers and I can't do our jobs without this database.
