Access 2003 and Excel

[countryhouse]

I am aware that Microsoft, in their infinate wisdom, has decided to block
the ability to update linked Excel files from within Access 2003. My
question is, when are they going to fix this issue? I foolishly installed
Service pack 2 yesterday, in hopes that some amazing had happened, and
updating linked files suddenly works. I see now that it doesn't so I will
once again have to uninstall 2003, and reinstall it without service pack 2.

 

[Klatuu]

It was not Microsoft's infinite wisdom, it was a lost law suit. Some dufus
in (i think) Brazil claimed he invented and has a copywrite on the method
being used to do that.

I think you may have a problem trying to back out SP2. I have not
experienced it, but I have heard that it can't be backed out. It may take
wiping the disk and reinstalling everything.

A work around for this problem is to use automation to write directly to the
spreadsheet.