Collecting data remotely and centralizing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Doug F. - 27 Apr 2008 04:00 GMT

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!

Reply to this Message

Jeff Boyce - 28 Apr 2008 18:23 GMT

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

>I need to collect confidential data at many remote independent sites
> (physicians offices) and periodically gather this data centrally.
[quoted text clipped - 5 lines]
> Thoughts?
> Thanks!

Reply to this Message

Doug F. - 29 Apr 2008 18:14 GMT

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

> Doug
>
[quoted text clipped - 19 lines]
> > Thoughts?
> > Thanks!

Reply to this Message