Limited Access Database

D

DDrowe

I have a database with the Access security features turned on. I want a
certain set of people to be able to go in and modify the current record but
not previous ones. In fact I don't want them to even be able to see previous
records - only the current (latest) one.

How do I do this?

Thanks
 
J

Jeff Boyce

First, define "the current record"...!

If you are saying that once a record's been saved, you don't want folks to
modify it, you could provide a 'data-entry-only' form, and no other
mechanism for (casual) users to see data.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

DDrowe

OK - how do you specify "the current record"? This would be the latest
unfilled form. Also, do you specify this (data-entry-only) in the Security
features or on the form itself?
 
J

Jeff Boyce

"Record" is a table-concept ... "unfilled form" is a form-concept. I'll
stick with my first hunch that you want a way to allow a user to create a
new record (via a form), but not see nor edit already existing records.

Change the form's DataEntry property, or use a command button to open the
form, with the syntax that opens it as a DataEntry form.

When the users use this kind of form, they have a blank form. When they
finish and <Save>, their data disappears! and they have another blank form.

I know that I have been known to make misteaks ... who will right the wrongs
your users enter?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

DDrowe

These will be fairly sensitive items with names and dates - accident reports
basically. The person requesting the database wants it to be secure (as
secure as these can be). If a mistake is made either someone in the EHS
department will have to modify it or it will be my duty. I don't know if
this make sense or just rambles.

If someone on the plant floor fills out an accident report (or investigation
report). I want the EHS dept and myself to be able to see the report when
ever needed but I don't want anyone else to be able to got through the list
and read what other people have written.

Thanks for the help.
 
S

Steven Chicago,Illinois

DDrowe,

Try openning your database as a user and see what things you can get to.
Any design tools, tables, etc.. Also if they can print sensitive data is
there any way you will be able to track down who did it? How about forcing
there signon name to be on each page printed?
Good Luck
 
S

Steven Chicago,Illinois

DDRowe, The signon name is in a table somewhere. You create the
reports/queries, add the signon name as a data field in the query and the
report and maybe the forms that they use to display data. That way if they
print, print screen, or just leave the screen sitting open and unattended,
you can identidfy the user that signed on and caused the security breach.
 
Top