User Profile
JLindquist558
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Database design
Management has decided not to fill the vacated Software Developer position. We need a project tracking/data collection database and I (the statistician on the project) have been assigned this task. We will be using a SQL backend with Access front end set up. I do have a SQL support person. But I have some data security/PHI/PII concerns since this is health data. We have Individuals entering information at 6 different sites, but they should not be able to view each other’s data. The project manager needs to access data from all 6 sites. Project will continue to add more sites. Question – What framework should I use? I have considered one database, with site specific Access front ends linked to views limited to that site. Or six independent databases, that feed into one for the Project manager. Or something else. I was involved with Access programming 15 years ago (ie prior to Software Developer position being created) and have some catching up to do! Thanks for your help.959Views0likes1Comment
Groups
Recent Blog Articles
No content to show