Hello,
I work in health care and I need to create a large database, which can be filled in by secretaries.
This database is filled with the private data of our clients.
My other co-workers, which treat these clients, need to be able to see and edit the data of their own clients, but they are not allowed to see the data of other employees.
Does anyone have any ideas how I achieve this?
I've tried creating one large file, which opens the other files, extracts the required data and then closes them again. the drawback to this was that it that it took too long.
I've also considered doing it the other way around, so I have experimented a litte with it. I tried having each co-worker file open the secretary file and copy it's changed values into it, but if something goes wrong with the macro, this would leave the secretary file open on a co-workers' computer.
At this point I'm open to all suggestions, not necessarily only in excel. Maybe this is possible when combining excel with access or something?
Please let me hear any thoughts you have on this, even if it's not a straight out solution!
Bookmarks