Jet OLEDB driver refuses to open a linked table where the original has a lock - any way to force this?
Found the problem - permissions issue in disguise.  The Jet driver needs to have write access on the directory so it can update the lock files.  When it can't write to the lock files it throws its toys out of the cot with a misleading error message.