I would like to be able to reference and use a query, directly from the Access database, as the update command in my separate Visual Studio 2012 Visual Basic Windows Forms Application. My Access .mdb database (originally created with Access 2007 but current running Access 2013) contains the following update query, named Current Update Query. I wish to update the existing column and row variables in the Current Table as shown in the query sql view below. Update values would be read from the VB
form combo box text and text box text controls.
code would allow update of the Access Current Table values using this query and without cutting and pasting the sql from the query into the separate VB
project Data Sources include connection to MyDataSet and all associated Access Tables and Access Queries stored in DB.
Current Access DB includes DB update query named Current Update Query shown below.
Current Update Query:
UPDATE [Current] SET [Current].CurrentConfigName =
, [Current].CurrentParamID = [??], [Current].CurrentParamName = [???], [Current].CurrentAlgID = [????], [Current].CurrentAlgName = [?????], [Current].CurrentReportID = [??????], [Current].CurrentReportName = [???????];