Question Options settings returning to default

[LizLock]

I wonder whether this has happened to anyone else. I am finding that my Access options settings are returning to default on their own--in particular the Edit/Find find/replace behaviour and confirm options. Every time I open a database I find that I have Fast Search and Bug Me If I Run an Append Query selected, which is maddening. I even put this in the AutoExec macro:

Application.SetOption "Default Find/Replace Behavior", 1
Application.SetOption "Confirm Record Changes", 0
Application.SetOption "Confirm Action queries", 0

But it still happens. Does anyone have any ideas? Is this stuff stored in the registry?

Many thanks,

Liz

 

[ghudson]

Is this on your computer or your company's computer? Might be a group registry setting that is being changed [reset] each time you log into your company's computer.

 

[LizLock]

Thanks for the very quick reply! It's on a work computer, but I 'run' the network myself since our regular IT person quit. I don't know much about how it was set up, but he certainly wouldn't have done something like that. It started on my assistant's computer (which means every five minutes she dashes into the office and says 'I've got an error message!!') but this morning my own workstation started doing it. I really can't understand why the autoexec doesn't fix it! I wondered if something I was doing with a registry cleaner or even anti-malware was setting things back to default: I regularly use CCleaner, MalwareBytes, Avira and SpyBot Search and Destroy.

 

[ghudson]

Out of an old habit, I do something simular. The only thing my AutoExec macro runs is an AutoOpen() function where I run a bunch of code to setup the database when it is first opened. I have simular code running and never had any problems since these commands should over ride any registry settings [if that is where they are stored]

Public Function AutoOpen()
On Error GoTo Err_AutoOpen

    DoCmd.OpenForm "formnamehere", acNormal, , , , acWindowNormal

    vStatusBar = SysCmd(acSysCmdClearStatus)
    
    DoCmd.RunCommand acCmdAppMaximize
    
    Application.SetOption "Show Status Bar", True
    
    Application.SetOption ("Default Find/Replace Behavior"), 1 'General Search

 

[LizLock]

What I really don't understand, as you say, is why this doesn't override everything else every time the database starts. But this morning I had Fast Search and Panic on Action Queries. Could Microsoft updates be doing it? I don't let these happen automatically because I've had bad experience with security updates interfering with how the database relates to other programs (I use lots of automation).