Gustav Brock
gustav at cactus.dk
Fri May 7 04:05:29 CDT 2004
Hi Marty > That's kind of an old version of Excel. It is Excel 95 that you are > calling. You could try 8.0 That's what Access 2000 writes when you link worksheet or named range as a table. I don't think it matters; I tried with 8.0 but no change. > See SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data > in Excel Workbooks > http://support.microsoft.com/default.aspx?scid=kb;en-us;278973 > or > http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJetExcel > http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForExcel Thanks. Located this: http://support.microsoft.com/default.aspx?scid=kb;EN-US;211378 which tells a) to remove password (clever suggestion) b) to have Excel open while linking from Access However, following b), Access (97 or 2000) crashes using either code or the wizard, so at the best this wouldn't work reliably. This leaves a) as the clever solution ... /gustav >>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