WARN OF CHANGED OR DELETED DATA

  • Thread starter Thread starter BIGGREG
  • Start date Start date
B

BIGGREG

I WOULD LIKE TO WARN A USER THAT DATA HAS BEEN CHANGED OR
DELETE BEFORE THEY GO TO THE NEXT FIELD OR RECORD.
MOST OF MY DATA IS ENTRY OR VIEWED, BUT I HAVE USERS THAT
ARE ACCIDENTLY CHANGING OR DELETE INFO WITH OUT KNOWING
IT.
PLEASE HELP
BIGGREG
 
(1) Set the AllowEdits and AllowDeletions properties of your forms to
False. Then they can not edit or delete records.

(2) STOP SHOUTING!

HTH,
TC
 
Thank You
Thay will take care of my forms, but is there a way for
tables and queries.
Thanks
 
The only way to stop them making changes if they are using tables & queries
directly, is to implement Access "user level security". Unfortunately, that
is not a simple process! An alternative might be, to make them use forms
(not tables or queries directly), & use the property values that I suggested
for those forms. But without user-level security, they could still ignore
your forms & edit the tables & queries directly (if they wanted to do that).

Alternatively (or in addition):

* if they are erasing values for fields which should *always* have a value
in them, try setting the Required property of those fields in table design
view; then they can not change those fields to blank.

* perhaps use the Validation Rule & Validation Text properties to enforce
some data rules?

HTH,
TC
 
-----Original Message-----
The only way to stop them making changes if they are using tables & queries
directly, is to implement Access "user level security". Unfortunately, that
is not a simple process! An alternative might be, to make them use forms
(not tables or queries directly), & use the property values that I suggested
for those forms. But without user-level security, they could still ignore
your forms & edit the tables & queries directly (if they wanted to do that).

Alternatively (or in addition):

* if they are erasing values for fields which should *always* have a value
in them, try setting the Required property of those fields in table design
view; then they can not change those fields to blank.

* perhaps use the Validation Rule & Validation Text properties to enforce
some data rules?
Thanks for the info, it will help alot.
Click to expand...
But on the tables abd queries, is there a way a window
could open if data is changed or deleted, cause most of
the problems that i'm geting are accidental.
thanks again
biggreg
 
But on the tables abd queries, is there a way a window
could open if data is changed or deleted, cause most of
the problems that i'm geting are accidental.
thanks again
biggreg
Click to expand...


No! If you let them directly edit tables & queries, they can make whatever
changes they like, as long as they objey whatever field- and table- level
validation rules you have set for the tables. Those rules would not, for
example, prevent them from deleting records. If you want to control how the
users change data, you really must make them do all updates *through forms*.
Then you can write VBA code in the forms, to control what they do. And/or
you can implement "user level security", to do some or all of that.

HTH,
TC

(snip rest)
 
Back
Top