Deploying Database with Split Tables

  • Thread starter Thread starter Anthony Ching
  • Start date Start date
A

Anthony Ching

I tried to deploy a database application with data (tables) split. I have
cleared the "Action queries" check box under Access Options. I have also
included the source (application logic file location) and destination (data
over the network) as trusted locations. However, the query prompts "You are
about to run an update query that will modify data in your table" keeps
coming in.

Can any body help. Thanks.
 
However, the query prompts "You are
about to run an update query that will modify data in your table" keeps
coming in.
Click to expand...

This is a warning issued whenever you're going to run an action query. It has
nothing to do with splitting or permissions.

You can execute the query from a macro or from VBA code, and precede it by
Setwarnings No (DoCmd.Setwarnings No in VBA); *BE SURE* to follow it by
DoCmd.Setwarnings Yes, or you'll turn off all warning messages for the
session. Or you can use the Execute method to execute a querydef; this doesn't
give the prompt.
 
This is a warning issued whenever you're going to run an action
query. It has nothing to do with splitting or permissions.

You can execute the query from a macro or from VBA code, and
precede it by Setwarnings No (DoCmd.Setwarnings No in VBA); *BE
SURE* to follow it by DoCmd.Setwarnings Yes, or you'll turn off
all warning messages for the session. Or you can use the Execute
method to execute a querydef; this doesn't give the prompt.
Click to expand...

Or, you can use my SQLRun() function to safely execute any arbitrary
action SQL. Code after my .sig.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Public Function SQLRun(strSQL As String) As Long
On Error GoTo errHandler

CurrentDB.Execute strSQL, dbFailOnError
SQLRun = CurrentDB.RecordsAffected

exitRoutine:
Exit Function

errHandler:
MsgBox Err.Number & ": " & Err.Description, vbExclamation, _
"Error in SQLRun()"
Resume exitRoutine
End Functio
 
Thanks, that's helpful.
--
Anthony


John W. Vinson said:
This is a warning issued whenever you're going to run an action query. It has
nothing to do with splitting or permissions.

You can execute the query from a macro or from VBA code, and precede it by
Setwarnings No (DoCmd.Setwarnings No in VBA); *BE SURE* to follow it by
DoCmd.Setwarnings Yes, or you'll turn off all warning messages for the
session. Or you can use the Execute method to execute a querydef; this doesn't
give the prompt.
Click to expand...
 
Back
Top