Linked spreadsheet is read-only

[countryhouse]

I have been linking Excel spreadsheets to an Access database to update it,
for some time now. All of a sudden, <g> I can't write to the linked
spreadsheet.

I may have done a microsoft update in the recent past, but I can't remember.
Regardless, I should be able to update these spreadsheets from within
Access. I assume there is a permissions for lock situation occurring, but
to be honest, I'm not sure where to look.

Any help would be appreciated.

John W.

 

[Allen Browne]

You're right, John.

Microsoft did cripple Access 2003 and 2002 so you can no longer update the
spreadsheet from Access:
http://support.microsoft.com/kb/904953/en-us

 

[countryhouse]

Thanks Allen. I suppose it's my own fault for not reading all the info for
the updates before installing them. I just never supposed that Microsoft
would do such a damaging deed to its own product.

I see that it cannot be removed. So I guess the workaround is to uninstall
Office and reinstall, leaving out the update? Is there another way?

John W.

 

[Allen Browne]

Not that I am aware of, but I've not really tried.