 |
 |
To add to Brian's answer, you'll almost certainly have to get the data protection methods approved by an ethics committee - if something goes wrong, you've got something to fall back on to show that you did everything you were supposed to do. This will depend on things like whether you have patient names (or other identifying information) in the database. J On 22 March 2013 07:09, Brian K. Saxby <[log in to unmask]> wrote: > Hi Lisa, > > The tool or service you use may be determined by the nature of the data and > the regulations you have to conform to. For example, I work in clinical > trials where we have to ensure there is full audit trail for the data from > source to analysis, in accordance with ICH GCP and FDA 21 CFR part 11 (as it > relates to electronic records), so Excel and Access are not suitable, but > regulatory-compliant packages like Oracle Clinical/ SAS are expensive. > Assuming your work doesn't require that level of compliance, Microsoft > SkyDrive is worth looking into as a file-sharing and syncing option, with > 7Gb free storage. > > If you create an Access database, then duplicate it, delete everything > except the data tables in one copy (e.g. data.mdb), and keep everything > except the data tables in the other (e.g. forms.mdb), and link them using > the Get External Data>Link Tables... Wizard, you can situate the data in the > shared space and have the forms, queries, reports etc. situated locally. The > forms.mdb is typically larger and you can update the forms without affecting > the data, and back-up the data without worrying about the forms. It also > means local users can create their own forms, or alternatively you can > control user permissions at the form level e.g. by providing them with a > local copy of the forms with read-only access (but of course they can always > go directly to the data tables, so it's not 'secure' but less prone to > accidental changes). > > Hope that helps, > > Brian K. Saxby > > > > On 22/03/2013 11:59, Lisa Graham wrote: > > Hi all, > > I'm wondering if you would have any suggestions. I'm conducting a multi-site > study and need a way of recording the data. > > I'm looking for a programme which will allow me to maintain a database (like > Excel or Access) online between several users. We all need to be able to > edit it. I'm not keen on Google Docs as it's for patient data so I need > something more secure if possible. It would need to have the ability to > track what changes the different users have made, in case something goes > wrong. > > Has anyone used a programme for this purpose in the past? Any ideas would be > much appreciated! > > Best wishes, > > Lisa > > ____________________________________________________________________________ > > Lisa Graham > PhD Research Student | PSYPAG N.I Representative > School of Psychology, Queen's University Belfast | BT7 1NN > > Email: [log in to unmask] | Web: QUB Webpage > > > > >