Intermittent problem - form doesn't update

[chogben]

We've got a form that doesn't allow the user to update the data on minute, but does the next. The changes look okay on the screen, but no change to the underlying data takes place. Any code that runs finds the 'old' data. So the screen updates, but the data doesn't.

Any ideas?

Recently upsized to SQL server. Connection via a user DSN. Access database is secured - I've checked permissions on both Access and SQL server - all good.

Problem affects Access Run Time and full version. Each user has their own copy (.vbs script acts like a shortcut - copying the front end database down to c:\ each time they start the database).

 

[hymn]

Have you saved the data on the screen until you leave the record or save the record the data does not get saved into the table

Hope this helps
Hymn