I'll address two things here. First, auditing in Amazing Chats. Second, clinics having read-write access to their data outside of Amazing Charts such as through SQL Server Management Studio.
Amazing Charts handles auditing the way may softwares do, by placing "triggers" on various tables to record changes to records in the table they are on. Take the Demographics table, for example. The first attachment is its trigger. Note the trigger "fires" after any INSERT, UPDATE, or DELETE statement is run against the demographics table and records the results in the AuditLog table. If you want to disable auditing, then disable the triggers. Indy and I used to argue about AC auditing as well. He always seemed to think they had some "super secret super evil M$ thing" that allowed them to always know what was going on in any database at any time. Not true, I'm afraid.
As for clinics having read-write access outside of Amazing Charts, I am generally against it. I say generally because I do assist people with things like data clean up, deduplication, and so on. There are some things that just cannot be done easily within AC. And, using SQL Server Management Studio, you can really screw up your data in a hurry. So, yes, I will help people access their data but either A: I run the queries for them or B: I seek certain assurances they aren't about to shoot themselves in the foot AND I always ask if they have good backups.
.png "ACUF Donor I")
