Custom message for when record locking is set

[RichS]

Hi,

My database has been set with the 'All records' locking option set to prevent two or more people editing files at once. This is working fine but I wondered if there is a way to make a more personal message appear instead of the default Access one, just to maintain a uniform look.

Thanks,

Rich

 

[gemma-the-husky]

I presume you would need to intercept an error with the on error event, and replace the message.

personally, I do not use pessimistic record locking, though.

 

[RichS]

Cheers for the reply Dave.

Basically, the main reason I'm using record locking is that my database is used by several other people (not at the same time) but I am constantly making small improvements as it evolves for our business needs. I was finding that if somebody had entered some data whilst I was working on it, their data got corrupted and often my changes didn't save... So I've had to lock them out!!!!

I'll look into error handling although I'm not sure where the error will occur. Thanks for the suggestion anyway...

 

[gemma-the-husky]

i would have thought if just entering data causes problems, then there is something unusual going on.

the point about the error depends on what the error is. if it is a "normal" error, you may be able to handle it with a "normal" error handler

ie
on error goto fail etc

however, if the error causes more of an automation error - similar, say, to add a record that you are unable to do, because of relational integrity or other fields - then you do not get a trappable run time error - but you still get a "system"/automation error that you can manage with a forms error event.

I am not sure whether a "locking" error is of the former or latter type