Kamis, 24 Oktober 2013

Re: [MS_AccessPros] RE: block deletion of record

 

ok, thanks,

I unchecked "Display Navigation Pane" but any user can still check that back, even when you make a ACCDE file
is there a way to lock these options?


thanks,
Daniel



On Thursday, October 24, 2013 2:57:13 AM, Glenn Lloyd <argeedblu@gmail.com> wrote:
 
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.
 
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 (9)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar