James,
I didn't realize SQLserver Express wasn't compatible with the whole suite. I don't think I want to start switching server instances and all that.
I was also unhappy about AC not allowing access to the database. When I originally spoke to them about this, wanting to do some transfer of patient demographics into AC myself, they said this was out of concerns for security.
Actually, it seems to me this cuts two ways. If the password to AC's database is the same for everybody, but they don't give this password out to users, there is a security issue because anyone who does get hold of this password can now access everyone else's data. On the other hand, if each user sets their own password, this wouldn't be the case.
Then again, I suppose for medico-legal reasons there is some protection in not granting users the password. By withholding the password, users can't easily redact the medical record.
Not sure how these two issues balance each other.
Michael
---------------
Michael Jacobson,
New York, NY
