I created an Access DB project in Access 2007. The server in our office has Access 2003 but upgrading to 2007 requires that we purchase multiple copies for multiple seats so this got a little expensive.
I installed the 2007 runtime version on the server, changed the extension to .accdr and the program worked great, but none of the 2003 access DB's would work, because they were opening with the 2007 runtime. I right clicked on the 2003 version and told it to open with Access. This fixed the problem with the 2003 versions, but it set the default to open with the 2003 version, and I can't open the 2007 runtime program.
Is there any way to make the computer open the .mdb program with Access 2003 and the .accdr versions with the Access 2007 run time version.
I have searched extensively online but I can't find any information.
I would appreciate any ideas that you may have to resolve this.