Daniel-
You have to set database properties in Access Options. Clear Use Special Access Keys, Enable Layout View, and Display Navigation Pane. You must have a Startup form defined or have an AutoExec macro in the database. You also need to run a bit of code to define and set the AllowBypassKey property of the database. If this property is set to False, the user cannot hold down the Shift key while opening the database to bypass your startup settings that you have in Access Options. You can find how to define and set the AllowBypassKey property here:
http://support.microsoft.com/kb/826765
By the way, if you have Access 2010 or later, you can also define a Data Macro that will prevent deletions.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Dan Abc
Sent: Thursday, October 24, 2013 12:44 AM
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 (7) |
Tidak ada komentar:
Posting Komentar