Hi everyone. I do hope to get answers here.
PROBLEM: A shared database file won't open when double-clicked.
Here are the details:
(1) The database file is shared among five (5) users or computers.
(2) All the five (5) users can open the database file by double-clicking it, well only one user at a time.
(3) When User 1 opens the database file by double-clicking it (thus it is now open) and User 2 tries to open the same shared database file by double-clicking it, nothing happens in the computer of User 2.
(4) However, User 2 can open that shared database file by opening Microsoft Access first.
(5) The shared database file is made in Microsoft Access 2003.
(6) The shared folder where the database file resides is open to all users. They can cut, copy, paste, delete, edit etc...
(7) All users are using Windows XP Service Pack 2.
(8) The router is a Linksys WRT54N.
(9) All users are connected to the router via LAN UTP cable.
(10) Some users have their firewalls turned on. Others turned off.
(11) The database file was made in a development PC that's running in Windows 7 Ultimate.
(12) All users have their copies of Microsoft Access 2003 set to "Shared," which is the option found in Tools > Options > Advanced.
(13) File association is correctly set up.
(14) No error message is generated.
(15) The database file does not implement User-Level security (yet).
(16) The database file does not have a database password.
(17) The database file has been subject to conditions that can corrupt it, but I haven't encountered any message telling it's corrupt... Sudden shutdown of PC, hibernating, Access was forcefully shut down by clicking the "End Now" button.
(18) No database object was ever corrupted: tables, queries, forms, reports, modules, pages.
(19) The database's VBA uses DAO in some areas.
(20) No object-oriented programming.
Thank you so much guys. Please excuse me when I commit mistakes in English because I'm not a native speaker. By the way, I'm not an IT professional.
-evander-