Limiting users to Write-Only

[marcustofeles]

Having a security issue that I'm struggling to find a solution for.

Objective: Create a DB where every company user is allowed to add new records but not read existing records. Any ideas?




Background: Users are to use DB to record possibly sensitive issues related to work environment. These records should then only be possible to be read by user on manager levels.
Best option I've come up with so far is to disable the Navigation Pane + disabling shift key on the FE, and then password protect the BE, but that doesn't seem secure enough.

Most appreciative for any help!

[ArviLaanemets]

The table (e.g. YourTable) has a smallint field (e.g. IsSaved);
The form has datasource like "SELECT * FROM YourTable WHERE IsSaved = 0". The form has hidden control with IsSaved as source (txtIsSaved).
Whenever the record is saved, BeforeUpdate event of form sets txtIsSaved = 1;
AfterUpdate event of form requeryes the form.

[isladogs]

I would do all the security measures you suggested and much more. See my extended two part article of improving security in Access databases http://www.mendipdatasystems.co.uk/i...ity/4594461803

For your immediate issues set Data Entry =Yes in the form properties or use code to open it :

DoCmd.OpenForm "FormName", , , , acFormAdd

You will also need to provide a button code visible only to managers that allows existing records to be viewed

DoCmd.OpenForm "FormName", , , , acFormEdit

[marcustofeles]

Thank you very much gentlemen!