Backtrack:  
 
by lunarg on October 13th 2011, at 11:15

There's an obscure issue with Access 2003, not being able to open an MDB from a network location via Explorer. It outright refuses to open the file, so when attempting, nothing seems to happen.

Cause

This is caused by security measures in Access 2003, where you normally have to confirm to open the file, which fails. However, I'm guessing this is not by design that it does not open at all.

Workaround

A workaround is to create a shortcut to said file, then edit the shortcut so it reads:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /NOSTARTUP "MyFile.MDB"

Adjust the installation path and file location to your needs.

This way, Access gets started first, with the file as parameter, so it gets opened.

 
 
« February 2025»
SunMonTueWedThuFriSat
      1
2345678
9101112131415
16171819202122
232425262728
 
Links
 
Quote
« Debating Windows vs. Linux vs. Mac is pointless: they all have their merits and flaws, and it ultimately comes to down to personal preference. »
Me