这就是我最终在https://codingdict.com/questions/220955帮助下解决此问题的方式。事实证明,Access在所有查询之间共享参数,因此无需专门将参数从一个查询传递给另一个查询。
查询1:
SELECT * FROM Customer WHERE ID > [param1] AND ID < [param2]
查询2:
SELECT * FROM Query1
VB.NET代码:
Dim ConnString As String = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=Database.mdb"
Dim sqlString As String = "Query2"
Using Conn As New OleDbConnection(ConnString)
Using Cmd As New OleDbCommand(sqlString, Conn)
Cmd.CommandType = CommandType.StoredProcedure
Cmd.Parameters.AddWithValue("param1", "1")
Cmd.Parameters.AddWithValue("param2", "3")
Conn.open()
Using reader As OleDbDataReader = Cmd.ExecuteReader()
While reader.Read()
Console.WriteLine(reader("ID"))
End While
End Using
End Using
End Using