No current record

[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

 

[Stefan Hoffmann]

hi Lars,

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?

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 <--

 

[Lars Brownies]

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