Access Options - Client setting (1 Viewer)

Gismo

Registered User.
Local time
Today, 11:26
Joined
Jun 12, 2017
Messages
1,298
Hi All,

i need to give access to my DB to quite a few users
when a user opens access for this first time, the clients settings under access options are all set to confirm record changes / document deletions / Action queries

how do I make these inactive when a user opens the DB for the first time?

also, how do I make the DB location a trusted location for a security warning on first opening the DB?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:26
Joined
May 7, 2009
Messages
19,169
just instruct the user that on the first time opening the db, a security warning will appear and
that they need to acknowledge it.

on the first question you add an autoexec macro that calls a function
which in turn set/unset the confirmation dialog.
 

Gismo

Registered User.
Local time
Today, 11:26
Joined
Jun 12, 2017
Messages
1,298
just instruct the user that on the first time opening the db, a security warning will appear and
that they need to acknowledge it.

on the first question you add an autoexec macro that calls a function
which in turn set/unset the confirmation dialog.
Thank you

by any chance, could you please provide code for autoexec?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 02:26
Joined
Oct 29, 2018
Messages
21,357
Thank you

by any chance, could you please provide code for autoexec?
Hi. See if you can find some of them here. I would also recommend you turn them back on when your db closes.
 

Isaac

Lifelong Learner
Local time
Today, 02:26
Joined
Mar 14, 2017
Messages
8,738
how do I make these inactive when a user opens the DB for the first time?
The way I would recommend doing it is to wrap any code that performs those actions like so:
Code:
On Error goto Errhandler

...any code here

DoCmd.SetWarnings False
...Your code to perform the action query or object deletion
DoCmd.SetWarnings True

Exit Sub/Function
Errhandler:
...whatever message
DoCmd.SetWarnings True
...Rather than trying to set them to, essentially, Off/False, permanently.

This recommendation assumes that you develop applications for end users, and do not allow end users to perform any design-type of action.
 

isladogs

MVP / VIP
Local time
Today, 09:26
Joined
Jan 14, 2017
Messages
18,186
By definition, client settings cannot be 'locked' by the developer.
All you can do is prevent end users accessing Access options but you can't overrule previously entered settings.

The only guaranteed way to set the location as trusted when the app is first opened is to distribute your app using a professional installer application.
Doing so allows the installer to create trusted location registry entries so these are in place before the app is used for the first time
Otherwise any security measures you impose can easily be circumvented by a knowledgeable end user using the shift bypass to open the app whilst it is still 'not trusted'
 

Users who are viewing this thread

Top Bottom