A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Medico-legal problem



 
 
Thread Tools Display Modes
  #1  
Old May 28th, 2004, 11:41 AM
DubboPete
external usenet poster
 
Posts: n/a
Default Medico-legal problem

Hello all again!

I have a database which is under construction, and it has to be assessed and
certified by our medico-legal people.

One requirement is that any clinical notes entered into a particular memo
field in a table table CANNOT and I stress CANNOT be deleted, removed,
altered and so on.

This is a legal requirement.

How do I achieve this?
I realise that this may be complex, but I would appreciate any help.
Yes, the database is secure, with user logins and passwords, usergroups,
etc...

TIA

DubboPete



  #2  
Old May 28th, 2004, 02:26 PM
Rick B
external usenet poster
 
Posts: n/a
Default Medico-legal problem

You can accomplish this, but Microsoft Access is not that secure an
environment.

If you want to accomplish this, you would need to release the file in an MDE
format first of all. Secondly, you would have to take away access to all
the tables and queries from all the users.

If table and query access is not granted, the users would be forced to do
everything through forms based on queries. Since they don't have access to
the queries, you would have to run them using the 'owner's permissions.

After you do all this, you would need to code the form in such a way that
the notes field allows entry, but is locked when reviewing any records.

Again, MS Access is most likely not the environment to use if you truly need
to assure your legal team that changes can't be made. Most savvy users
could get around many of the features above.

Rick B

"DubboPete" wrote in message
...
Hello all again!

I have a database which is under construction, and it has to be assessed and
certified by our medico-legal people.

One requirement is that any clinical notes entered into a particular memo
field in a table table CANNOT and I stress CANNOT be deleted, removed,
altered and so on.

This is a legal requirement.

How do I achieve this?
I realise that this may be complex, but I would appreciate any help.
Yes, the database is secure, with user logins and passwords, usergroups,
etc...

TIA

DubboPete




  #3  
Old May 29th, 2004, 02:45 PM
Peter R. Fletcher
external usenet poster
 
Posts: n/a
Default Medico-legal problem

I would do everything that Rick suggests, but I would also keep and
save a hash of the contents of the field, using a secret key, in
another field in the table when it is first created. you can then
"rehash" the memo field's contents every time they are used to make
sure they haven't been changed. This adds very significant further
difficulties for someone who tries to make an unauthorised change, and
I suspect that your lawyers will like it.

On Fri, 28 May 2004 20:41:55 +1000, "DubboPete"
wrote:

Hello all again!

I have a database which is under construction, and it has to be assessed and
certified by our medico-legal people.

One requirement is that any clinical notes entered into a particular memo
field in a table table CANNOT and I stress CANNOT be deleted, removed,
altered and so on.

This is a legal requirement.

How do I achieve this?
I realise that this may be complex, but I would appreciate any help.
Yes, the database is secure, with user logins and passwords, usergroups,
etc...

TIA

DubboPete



Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher


----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.