No current record

  • Thread starter Thread starter Lars Brownies
  • Start date Start date
L

Lars Brownies

After getting the dialog 'the edits can't be saved because it was in use by
another user' in which the users has 3 options, users sometimes get the
undefined error 'No current record'. I haven't been able to find out why
this exactly happens. I would like to prevent this error to appear. Any idea
how I can accomplish that?
Thanks, Lars
 
hi Lars,

Lars said:
After getting the dialog 'the edits can't be saved because it was in use by
another user' in which the users has 3 options, users sometimes get the
undefined error 'No current record'. I haven't been able to find out why
this exactly happens. I would like to prevent this error to appear. Any idea
how I can accomplish that?
Click to expand...
1. Depending on the unknown Access version, updating it may help.
2. Check the involved primary keys. They should (must) not contain
imprecise data types NUMBER (SINGLE or DOUBLE). If your using a SQL
Server backend append a ROWVERSION column to each table and relink them.
3. Use defensive programming including pessimistic locking.

Otherwise, tell us a little bit more.

mfG
--> stefan <--
 
Thanks Stefan.
It's Access 2003 BE-FE. Primary keys are autonumber fields. Data editing is
done through bound forms. Default locking is 'no locks'. Introducing
pessimistic locking I think would be a huge re-write.

Lars
 
Back
Top