User level security advice

[Guest]

We have an Access database running from a secure folder on our network drive.
I’m the only person who can give users access to the database. When they do
have access there is no further security.

We have a problem, staff don’t seem to be using the system correctly and how
they were trained to do so, despite many efforts to re-train and educate the
data entry staff. As far as I’m aware there’s no way to isolate which staff
are responsible without User level security.

I’ve never used user level security before so I’m not sure if its really
necessary for this problem.

Can anybody offer some suggestions??

Thanks very much

Ian

 

[Guest]

Implementing User and Group Accounts along with User and Group Permissions
appears to be necessary.

 

[Scott McDaniel]

User Level Security would force users to login to the application, but
depending on what you mean by "staff don't seem to be using the system
correctly", you may need to implemnet some form of auditing or loggin scheme
where you capture the actual user who edits/updates a record. Allen Browne
has a good sample on his website: http://allenbrowne.com/AppAudit.html.

If all you need to do is determine who is logging into your account, you can
capture the Network login name at app startup ...

 

[TC]

I agree with Scott. The answer depends entirely on what the data entry
staff are doing wrong.

For example, if they are entering invalid customer codes on invoices,
this just means that the database does not have the "referential
integrity" definitions that it should have. Those kinds of problems are
not staff, or training, or data entry, problems - they are database
design & coding problems!

HTH,
TC