I know, and I was REALLY surprised when it worked, but I knew that the
machines that were having the problem had all been "upgraded" to SP3, so it
made sense to try it.
Some further light: I was having an issue where Access 2003 (using
an .adp) would crash if i Compact/Repaired or tried to set up
Conditional Formatting. When I got in touch with MS (about six months
ago) I was told that it was a known issue but the fix hadn't made it
into SP3 and they didn't have a hot fix yet. The temporary solution
was to shut down the Sql Server service, do my C/R or set up
Conditional Formatting, then restart service. They said it was some
weird interaction between Sql Server 2005, Access 2003 and 2007 on the
same system. This worked but was incredibly irritating. Two weeks ago
I got tired of waiting and emailed the support engineer (very helpful
during the whole process, I must say) and he pointed me to this
hotfix. After installation no more problems. It does make me wonder
though, since this apparently was released in Dec. 07, why I wasn't
pointed here earlier.
Must be lots of wonderful things in this update.....