Re: Medico-legal problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rick B (anonymous_at_discussions.microsoft.com)
Date: 05/28/04 

Date: Fri, 28 May 2004 08:26:14 -0500

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" <pcastlehouse@"nospam"ozemail.com.au> wrote in message
news:UHEtc.317$Ix2.4685@nnrp1.ozemail.com.au...
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

Relevant Pages

  • Re: Vetting
    ... question of what they are trying to accomplish. ... to secure their power for self gratification you are right. ... this shows your real agenda and it's basically the FAUX NEws agenda of ...
    (misc.transport.road)
  • Re: Sample HR database
    ... Not sure how that changes the security issues I posted. ... tell us what you want to accomplish and we might be able to give you ... Rick B ... Access is not a secure environment. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: webmail application for production?
    ... > I don't want to take any security risk here, so i really need a secure ... I currently use both Squirrelmail and Horde/IMP in production. ...
    (RedHat)
  • RE: Should webservers, eg. IIS 6 have anti--virus installed on th em?
    ... In my environment, ... It won't protect the box from ... great number of things you can do to secure a Windows ...
    (Focus-Microsoft)
  • Comments concerning TR 24731
    ... TR 24731 is a proposal for making the C library more secure. ... This would eliminate the errors of passing a wrong buffer size. ... constraint handler. ... could mean in a ulti-threaded environment. ...
    (comp.std.c)