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 (5) |
Tidak ada komentar:
Posting Komentar