Printable View
I am accessing an Access file over a network. If one user deletes whilst another is editing the same record I get an error. Does anyone know how I can tell if anyone has the record open? Also if a record is deleted and onother user goes forward past the deleted record on an opened recordset - they get a blank record showing where the deleted one was. I guess this is pretty basic stuff but can anyone help me with this learning curve please?
In any well designed, multi-user database you need to consider all the possible errors that can be generated because of inadvertent user interaction. There isn't a good way to condense all this... but there are some multi-user issue articles in the MS Knowledge Base that are worth reading. Generally, you let the app run along and trap all the errors that can be occur when you do an Update, Delete or Insert. Then figure out what to do about them.
Good luck.
Bash