Prev: SQL Update and NOW
Next: dcount in a crosstab query
From: sphelps on 19 Mar 2010 07:32
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

From: Jerry Whittle on 19 Mar 2010 09:06
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
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"sphelps" wrote:

> 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
>
> .
>
From: sphelps via AccessMonster.com on 21 Mar 2010 08:13
Access 2003.

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

Regards
Steve

Jerry Whittle wrote:
>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]
>>
>> .

--
Message posted via http://www.accessmonster.com

 | 
Pages: 1
Prev: SQL Update and NOW
Next: dcount in a crosstab query