Rookie Multiple users-Chaning data

[Steve_G]

We are using acces to track and tag all incoming jobs. Since can be used by multiple users I would like a dialog box that would come up at open and tell me the file is currently being used by another user. Excel has that feature. Otherwise we keep using duplicate job numbers. Any help is appreciated.

 

[dbrown78]

Hi,

Would it be possible to change the table structure so that the job reference number is the Primary Key for it's table (setting the Indexed property of the job ref field to Yes (No Duplicates))? That way, whenever someone tries to enter a duplicate ref Access will flag a warning. It's not perfect, but it's a start...

Cheers