ExecuteAccessCommand

×V4.3Ø

Syntax -

ExecuteAccessCommand <Path to Database> <Query> <Access Version> <Replace Single Quotes>

       Where:

       <Path to Database> is a literal string or a variable that contains a literal string.

       <Query> is a literal string or a variable that contains a literal string.

       <Version> is a literal string or a variable that contains a literal string of value "Access2003" , "Access2007" or "Access2010"

       <Replace Single Quotes> is a literal string or a variable that contains a string value of “Yes” or “No”

Description:

This command is used to execute the query provided in the <Command> against the Access data source specified by the <Path to Database>.  Frequently, this  will be an INSERT, UPDATE, or DELETE statement, although any syntax which is valid to the specified data source can be used.

The <Access Version> parameter takes one of the following values and reflects the version of Access that is specified by the <Path to Database> parameter:  Access2003, Access2007, Access2010.

The <Replace Single Quotes> parameter, if set to Yes will replace all occurrences of single quotes in the <Command> with double quotes.  This parameter will be necessary when your data source requires double quotes in the command because it is not possible to express double quotes inside a literal string in EMUE.   To use this option, you can use single quotes instead of double quotes, when building the <Command> and set the <Replace Single Quotes> parameter to “Yes”.

Sample:

ExecuteAccessCommand "C:\PTDB\PTDB.MDB;" "UPDATE [PatientList] SET [Last Name] = ‘JONES’ WHERE PT_ID = 2;" "Access2010" "Yes"