We have an Access 2000 database that 2 computers were sharing. The host (PC1) computer has Access 2003 installed and PC2 has Access 2000 on it. PC1 shares the database folder and PC2 maps a drive to the folder. It has worked well until now.
All computers on the network are Windows XP.
We recently added a 3rd computer (PC3) to our network. It has Access 2007 and can open the database, but only when no one else has it open. PC3 can't open the database when it is in use if the file is doubleclicked directly. PC3 CAN open the database when it is locked if the file is opened manually from the file menu.
I have checked to make sure that all computers are opening in Shared mode and not Exclusive mode in the Options. A lock file does appear when a computer has the DB open.
I think I am having a similar problem as this question, but don't have any Access expertise.
I should also say that this same problem also happened to PC2 when PC1 had to be reformatted, reinstalled and restored. Is there a setting on PC1 that we have wrong?