Collecting data remotely and centralizing

[Doug F.]

I need to collect confidential data at many remote independent sites
(physicians offices) and periodically gather this data centrally.
Using Access as a platform (Runtime?), any suggestions on approach?
e.g. I know that I can create a password protected Excel file from within
Access and maybe even automatically email it, but is that enough?
Can I write VBA code to encrypt data?

Thoughts?
Thanks!

 

[Jeff Boyce]

Doug

You don't mention the regulatory and legislative restrictions under which
your collection of patient information (assuming "confidential" and
"physicians offices" means you'll be collection patient data). Whether your
approach is sufficient to satisfiy these depends on what "these" are...

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Doug F.]

Jeff, thanks.
We are in the early stages of design so I don't yet know of the regulatory
requirements. I'm not in the USA and yes it's collecting patient data which
would include demographics and medications.
Your first reply was useful as it made me recall some standards that
crossed my path say 7 years ago.

So, I'm wanting to understand the range of possibilities in order to bring
them to the table. eg what kind of human resources, skill sets are required.

Thanks,
Doug