I'm having some trouble using Microsoft Access 2003 through a DFS setup. I can only open access .mdb files (frontend) by going to file>open> and selecting the database. If I double click on them or use a shortcut nothing happens. Strangely if no one else is in the database I it works fine, which would lead me to believe it is to do with lock files but then why can I open the file by going to file>open? Is there some kind of issue with DFS,mdb files and the way they are used?
If you are running from a shortcut then ensure the shorcut doesn't have /EXCL in it.
Finally ensure the default open mode is shared.