一般的用法就和表查询一样,比如:在ACCESS中有个查询query_tb,VB代码中可以: select * from query_tb如果在ACCESS中建立的是参数查询,那么可以在VB中用ADODB.Command对象来调用。方法和调用SQL server的存储过程一样
dim cn as new adodb.connection dim rs as new adodb.recordsetcn.CursorLocation = adUseClient cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\BillSale.mdb;Persist Security Info=False" rs.open "select * from [查询], cn, adOpenStatic, adLockReadOnly
select * from query_tb如果在ACCESS中建立的是参数查询,那么可以在VB中用ADODB.Command对象来调用。方法和调用SQL server的存储过程一样
dim rs as new adodb.recordsetcn.CursorLocation = adUseClient
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\BillSale.mdb;Persist Security Info=False"
rs.open "select * from [查询], cn, adOpenStatic, adLockReadOnly