I had this same problem after installing Snow Leopard, I tried everything that Adobe told me to and nothing worked. Most of the things that they wanted me to do was with changing permissions, so that got me thinking…
I first enabled the root user and then logged out of my account.
Logged into the root user, then uninstalled CS3, then re-installed CS3 directly after.
It fixed the problem on my machine.