Before I start, I want to clear the air – I know all about using front-end and back-end MDB files. I co-wrote a high-availability EDI app for a prominent paper industry manufacturer in Access, with integration into Sterling Commerce’s Gentran EDI server. That application would simply have not worked without an FE/BE design. I’m also not talking about all the little spots where you can specify exclusive open access. I’m assuming you know about those already, or your diligent Google searching wouldn’t have brought you here.
But what I want to post about, in order that it helps others, is using just a plain ol’ .mdb file on a network share. The problem is when someone has it open, and anyone else goes to open it, it doesn’t do anything at all. Double click, no response.
The problem is Access 2007. Don’t believe me? Have multiple machines open the file, machines where Access 2007 has never been installed. Access 2003 will handle this just fine.
Still don’t believe? Convert the file to .accdb, and have multiple Access 2007 computers open it. No problem!
Access 2007 does something different when it opens a file, and it can’t see the ‘shared’ mode for opening when you do it across the network. I’ve seen a few posts that mention solving this by installing Access on the file server itself, but I don’t like that idea. Not for my file server.
Do try this at home. There’s your explanation, in spite of the compatibility between Access 2007 & previous versions. Unless a patch comes out and fixes it.