Access Advanced Settings

driver7408

Registered User.
Local time
Yesterday, 17:14
Joined
Feb 7, 2010
Messages
72
Before I distributed my database frontend, I went into the Access Options and set the Confirm Record Changes, Deletions, and Action Queries all to unchecked (off). My db runs many update and delete queries and I do not want those message boxes confusing my users.

For some reason, I am having a few users on other machines tell me that they are getting those access notifications at various times when my action queries are being run. Since I turned those off, I would assume they shouldn't be showing on other machines, as this is supposed to be a database setting.

Is there something that I am overlooking here or is this some sort of Access bug?

Thanks
 
Did you test these settings before distributing? Did the settings work as expected during testing? Is it possible a user(s) has modified the settings?


Usually with Action queries, the preferred approach is to use

Currentdb.Execute ActionSqlstringHere,dbFailOnError

This does not request the confirmation, and will report an error if such occurs.
 
Yes, I tested it extensively and none of the warnings were occurring. I doubt anyone went in there to mess with any of the settings. None of these guys have any clue how to use Access nor would they intentionally mess with it. The only thing I can think of is on one of the computers, those settings aren't being applied to the db for some reason.
 

Users who are viewing this thread

Back
Top Bottom