This post at UtterAccess.com has a good discussion with a utility attached for securing the back end about as well as can be done. Several versions of code to prevent shift-key bypass are available on the net including this one, again at UtterAccess.
Glenn
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Dan Abc
Sent: Wednesday, October 23, 2013 6:44 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] RE: block deletion of record
no, how to do that?
I can un-check show all access objects, but that can be changed later by users
I do make a ACCDE file
On Wednesday, October 23, 2013 3:36:44 PM, Glenn Lloyd <argeedblu@gmail.com> wrote:
Daniel,
Are you hiding the navigation pane and preventing shift key bypass? Are people getting to the backend and opening it directly?
Glenn
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Dan Abc
Sent: Wednesday, October 23, 2013 6:32 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] RE: block deletion of record
how to prevent access to table?
in my DB with forms I have only linked tables, but anyone can still open the table and add/delete records
On Wednesday, October 23, 2013 1:04:46 PM, "wrmosca@comcast.net" <wrmosca@comcast.net> wrote:
Daniel
Yes...Don't give them direct access to the tables EVER. All users should have to use forms for everything. With a form it's easy to set its Allow Deletions to No. Other properties are Allow Additions, Allow Edits.
---In ms_access_professionals@yahoogroups.com, <daniel2478a@yahoo.ca> wrote:
Hi All,
Is there a way to prevent anyone from deleting a record in a table?
Thanks,
Daniel
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (8) |
Tidak ada komentar:
Posting Komentar