I have an application that is being used by like 12 people for data entry purposes. Every once in a while they get a message about being locked by "user XXX on XXX machine". Then everyone has to kill their Access Process in order to get out and everyone looses their information. Is there a way to get my program to stop doing this???
a) rewrite the application not to lock rows
b) make sure any locks that have to occur always occur in the same order
c) don't use access
