Intermittent problem with update

C

Chris Hogben

We've got a form that doesn't allow the user to update the data one 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). The problem still occurs when there is only one user in the database...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top