Running a query against a password protected spreadsheet

[sphelps]

I used to be able to run an access query against a linked excel spreadsheet
and update information in the spreadsheet.

The spreadsheet is now password protected, and although I can run the query
against it OK, I can no longer update data in it.

Does anyone have any solution to this.

Regards
Steve

 

[Jerry Whittle]

What version of Access and how long ago were you able to do this? The reason
that I ask is that Microsoft lost a patent lawsuit a few years ago on
updating linked Excel worksheets from Access. I believe that they blocked
this ability from Access 2002 and newer.

http://support.microsoft.com/kb/904953

 

[Stefan Hoffmann]

hi Steve,

I used to be able to run an access query against a linked excel spreadsheet
and update information in the spreadsheet.

You need to automate Excel.

The spreadsheet is now password protected, and although I can run the query
against it OK, I can no longer update data in it.

Basically it is the lost patent law suite:

http://rogersaccessblog.blogspot.com/2009/11/this-recordset-is-not-updateable-why.html

mfG
--> stefan <--

 

[sphelps via AccessMonster.com]

Access 2003.

I can still update Excel spreadsheets from an access query if they are not
password protected.

Regards
Steve

What version of Access and how long ago were you able to do this? The reason
that I ask is that Microsoft lost a patent lawsuit a few years ago on
updating linked Excel worksheets from Access. I believe that they blocked
this ability from Access 2002 and newer.

http://support.microsoft.com/kb/904953

I used to be able to run an access query against a linked excel spreadsheet
and update information in the spreadsheet.

[quoted text clipped - 8 lines]

.