Can I Programatically Change MS Access Options? 2

[smedvid]

Just looking for a means to insure that the user will always have the Record Change Option under MS Access Turned On.

Under my current system, users can exit to Access and manipulate data, "by design". I want to basically insure a prompt if they are in a table and delete a record, that the confirmation record appears. My hope is that I can change and INI file or REgistry setting that most likely controls this option.

Any clues are helpful. tia,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[ad39311]

This code allows you to clear or set the option.

I usually store the current state before changing it, and later I restore the situation. In this way, the application does not change the users's settings permanently.

boolStatusRecordChangeConfirm = Application.GetOption("Confirm Record Changes")
Application.SetOption "Confirm Record Changes", True
<insert your own code, e.g. delete records>
Application.SetOption "Confirm Record Changes", boolStatusRecordChangeConfirm

Alex

 

[RoyVidar]

You are talking about the Confirm Record Changes in Tools | Options - Edit/Find tab?

[tt]application.setoption "Confirm Record Changes", -1[/tt]

Should do. Here's a reference Set Options from Visual Basic

Roy-Vidar

 

[smedvid]

Excellent - I was heading down that pathway myself... Thanks, it saved me research time and like all programmers, I'm on an impossible delivery schedule.

Steve Medvid
&quot;IT Consultant & Web Master&quot;

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...