[AccessD] Linking Excel with password. Error 3161: Cannot decrypt file

Gustav Brock gustav at cactus.dk
Thu May 6 11:02:57 CDT 2004


Hi all

If you try to link/attach an Excel range where the workbook is
password protected (Save as .. with password), you'll receive the
error above. 
The wizard can not accept a password.

I tried, in code, to modify the connect string with

  PWD=mypassword;

so it becomes

  Excel 5.0;HDR=YES;IMEX=2;PWD=mypassword;DATABASE=c:\temp\Test.xls

but that is not recognized when I try to do a RefreshLink - same
error.

Is this possible?

/gustav




More information about the AccessD mailing list