Dear All,

Is it possible to disable deleting records in a table or query ?

Filip

Yes and No

What are you using as the data store? Access Jet/Ace or some SQL database server.

If you are using Access native database to store the data and you allow people
to work directly with the tables and directly with updateable queries then it
is NOT possible to stop records from being deleted.

If you control all access to the data using forms then it is possible to
cancel any delete actions or preclude them in the first place.

Set all forms' AllowDeletions property to False (No) to not allow any record
deletion using the form.

If you want to you can also use code in a form's delete event to cancel
deletions. Normally you would do that when you wanted to run some checks and
allow deletion in some cases and prohibit it in other cases.

Private Sub Form_Delete(Cancel As Integer)
Cancel = True
End Sub


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

On 12/1/2010 5:21 AM, Filips Benoit wrote:

Thanks,

1. Years ago I told the company that it was better to use SQL-server as data
store but the were not willing to pay for it! Now about 10 frontends are
linked to the 1 access datastore-backend.
2. All deleting is unabled in the forms they should use but the new IT-man
simply has told some user they could go directly to the tables by using
shift while opening a database. Now some records has been deleted not
knowing who and when.
3. I think the user-permissions are not set properly so to many people can
use some databases they should not be able to open ! So I know that the old
It-man still can open all company's data!!!! Setting User-permissions is not
my job, so I'll have a nice conversation with the new IT-man.

Thanks,

Filip


Filip

"John Spencer" wrote in message
news:id5ffi$t9d$1 (AT) news (DOT) eternal-september.org...

Yes and No

What are you using as the data store? Access Jet/Ace or some SQL database
server.

If you are using Access native database to store the data and you allow
people
to work directly with the tables and directly with updateable queries then
it
is NOT possible to stop records from being deleted.

If you control all access to the data using forms then it is possible to
cancel any delete actions or preclude them in the first place.

Set all forms' AllowDeletions property to False (No) to not allow any record
deletion using the form.

If you want to you can also use code in a form's delete event to cancel
deletions. Normally you would do that when you wanted to run some checks
and
allow deletion in some cases and prohibit it in other cases.

Private Sub Form_Delete(Cancel As Integer)
Cancel = True
End Sub


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

On 12/1/2010 5:21 AM, Filips Benoit wrote:

Filips Benoit wrote:
Maybe you should also turn the AllowBypassKey property off.
See VBA Help for an example.

--
Marsh

Thanks,

very good suggestion !

Filip

"Marshall Barton" wrote in message
newsf8df6hvg5vp8vudlv5et1u6884avc4ccs (AT) 4ax (DOT) com...

Filips Benoit wrote:
Maybe you should also turn the AllowBypassKey property off.
See VBA Help for an example.

--
Marsh

On Wed, 1 Dec 2010 19:12:20 +0100, "Filips Benoit"
<benoit.filips (AT) telenet (DOT) be> wrote:

If Cascade Deletes are turned on for some relationships this will make
the problem worse.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

On Wed, 01 Dec 2010 13:30:47 -0600, Marshall Barton
<marshbarton (AT) wowway (DOT) com> wrote:

So long as moron IT person isn't reading this thread or others which
tell moron IT person to update the setting via code.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

maybe you should shut the fuck up and learn how to use SQL Server before trying to sell it?

Disabling delete is a simple SQL Server permission!