Can I link an Access table to a Password protected Excel Workbook?

  • Thread starter Thread starter WildlyHarry
  • Start date Start date
W

WildlyHarry

I have an excel workbook that is password protected for security reasons. I
need to be able to link a spreadsheet in that workbook to an access db. I
can create the link but when I try to do anything with the linked table in
access, I get an error that says that access cannot decrypt the file. Is
there anyway to link this spreadhseet without removing the password? Thanks
is advance for you help.
 
You should be able to read the file without a password, but you can't write
to one without it. If you think about it, that's how it should be. You might
try setting up a dsn on an ODBC connection and supplying the password. Even
better, just import the data into an Access table, instead of linking to it.
 
Thanks for the suggestion. As for the linked table I do not need to write to
it, just to include some data from it on reports. And it has to remained
linked becasue the excel file is updated daily.
 
Back
Top