Run Update Query silently in background

[ghadley_00]

I have a MS access 200 DB in which I have an update query which
repalces all the " " with ''" in a field. I would like the update query
to run in the background, and not ask the user for any perrmissions. I
was thinking to run the query as part of the autoexec macro.

can anyone recommend a way that I can have the update query run in the
background? I don't see an obvious way to set the SetWarnings command
for the query.

Any help would be greatly appreciated.

Best wishes,

George
gh********@yahoo.com

[Rick Brandt]

gh********@yahoo.com wrote:

I have a MS access 200 DB in which I have an update query which
repalces all the " " with ''" in a field. I would like the update
query to run in the background, and not ask the user for any
perrmissions. I was thinking to run the query as part of the autoexec
macro.

can anyone recommend a way that I can have the update query run in the
background? I don't see an obvious way to set the SetWarnings command
for the query.

Any help would be greatly appreciated.

Best wishes,

George
gh********@yahoo.com

CurrentDB.Execute "QueryName", dbFailOnError

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Steve]

Another way to do it is to use (in VBA):
On Error Resume Next
DoCmd.OpenQuery "qryName"

[Rick Brandt]

Steve wrote:

Another way to do it is to use (in VBA):
On Error Resume Next
DoCmd.OpenQuery "qryName"

I don't believe that would eliminate warnings and confirmation prompts.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Steve]

Sorry, I meant:
DoCmd.SetWarnings False
DoCmd.OpenQuery "qryName"
DoCmd.SetWarnings True

Don't know what I was thinking when I wrote the On Error Resume Next
bit.