Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Type mismatch error on set openrecordset statement 1

Status
Not open for further replies.

vzjfgm

Programmer
Jul 24, 2003
34
US
Dim dbsHOlD As Database, rstDAA As Recordset

Set dbsHOlD = DBEngine.Workspaces(0).Databases(0)
Set rstDAA = dbsHOlD.OpenRecordset("tbl_daa1_cleanup")


I get an error of type mismatch on the set rstDaa line
of code. The table is a valid table within the access project. I am working in Access 2000 and I have checked
the MS DAO 3.6 library reference. What am I doing wrong?
Thanks for any help!!
 
Never mind!!! I figured out the problem. I needed to
use the following statement.

Dim dbsHOlD As DAO.Database, rstDAA As DAO.Recordset
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top