Stop people deleting data in tables through query

[Epsilon101]

Hi, i couldnt find something on this through keyword search so i just want to send a quick forum message.

How do you stop people being able to enter new info into rows or deleting rows of a table through a query that is being displayed in preview.

---------------------------------------
Thanks for any help!

 

[Epsilon101]

When i say this, i mean to do it without using workgroup settings, so admin is set to the default system.mdb but if someone runs the query they cant enter something in or delete from it so they dont effect the main table.

---------------------------------------
Thanks for any help!

 

[Epsilon101]

.mdw even gah

---------------------------------------
Thanks for any help!

 

[OhioSteve]

You need to display your query in a form. Then go to the form's properties. On the data tab, you will see the properties that control user interactions with the data. Then just make the changes that you desire.

Incidentally, your question reminds me of another trick. If you are building an entire database, consider barring deletes altogether. On EVERY form, stop the users from deleting any records. Then, add a yes/no field to each table called "deleted". The default will be false. In your queries, set the criteria deleted=false. Finally, create custom delete buttons which set deleted=true (you may also want it to refresh the form).

ALL users eventually delete something accidentally. When they do this, they usually beg you for help. If you implement my system you can say "It will be tough, but I may be able to retrieve it" while actually you know that it will be easy to restore the record.

 

[Epsilon101]

Thanks for that

---------------------------------------
Thanks for any help!

 

[Crowley16]

lol OhioSteve...

don't forget to quote them a reasonable amount of retrieval time...

something along the lines of, it'll take 1/2 days...

then pop down the the local drinking establishment for a self congratulatory drink...

not that I'm advocating work avoidance or lazyness at all... ;-)

 

[OhioSteve]

Yeah, I received much of my technical training from watching Star Trek reruns. All those times Scottie said "It'll take at least a day to fix, capn!" he really knew that it would just take an hour.

 

[Epsilon101]

Lol

---------------------------------------
Thanks for any help!

 

[Crowley16]

shhhh....

that's an engineer's trade secret...

 

[koresnordic]

A pity my boss has cottoned onto this and when I say it will take a day, he asks is it a real day or one of my days. In which case he will expect it in 2 hours....



Graham

 

[Crowley16]

ahh...

koresnordic...

you've not been training your boss...

what you need to do is to slowly "adjust" his expectations...