Question regarding Adding through Forms

[scott04]

I have recently added a temporary table which helps me create an audit trail
of the records in my table. I have heard other people state that you should
only allow people to add records via forms but don't understand the steps to
make this happen. Can someone explain? I know I will benefit since my audit
only works if you are editing record via a form. Thank you for your help.

 

[Jeanette Cunningham]

Hi Scott,
It sounds like you are on the right track. If users of your database can
open the tables and add or edit the data in the tables you are in trouble.
If your users can only add or edit data through the forms in your database,
this is what you want and allows the audit trail to track which users edit
which record.

Jeanette Cunningham

 

[scott04]

Jeanette
How do you disallow them from adding or editing from the tables?
Scott

 

[Jeanette Cunningham]

Scott,
There is a bit of a procedure to follow:
When the database opens, the users should see the main menu for your
application.
The database window should be hidden from them.
Any menus they can use need to be set up so that users can't get access to
the database window.
There is quite a bit to do the first time you try to set this up, too much
for me to type here.
There are quite a few posts on this issue on past discussion groups, search
on the following:
Hide database window
Shift bypass key
Disable default menus

Post back when you need to

Jeanette Cunningham