<div>
You don't need to use New keyword in the declaration statement of Recordset.<br />
<br />
What is &quot;test_import&quot;??? Is it the table or sql?
</div>


You don't need to use New keyword in the declaration statement of Recordset.

What is "test_import"??? Is it the table or sql?

<div>
Thanks. It is the name of the table.
</div>


<div>
Your code seems to be working fine!!! Can you explain me more about your problem?
</div>


Your code seems to be working fine!!! Can you explain me more about your problem?

<div>
Are you using Access97 or Access2000?
</div>


<div>
There maybe a problem with the reference. Do you reference both ADO and DAO in your app? If so, you have to prefixed your declaration this way:<br />
<br />
Dim rs_test_import As DAO.Recordset 
</div>


There maybe a problem with the reference. Do you reference both ADO and DAO in your app? If so, you have to prefixed your declaration this way:

Dim rs_test_import As DAO.Recordset

<div>
if you are not using ADO then no no need to use ADO Reference
</div>


if you are not using ADO then no no need to use ADO Reference

<div>
<div class="content wysiwyg-content">
I have the following code that I swear was working. Now I get a type mismatch error. Can anyone shed some light on this..<br />
<br />
Dim rs_test_import As New Recordset<br />
Dim booksdb As Database<br />
<br />
&nbsp; Set booksdb = OpenDatabase(&quot;books2.mdb&quot;)<wbr /><br />
&nbsp; Set rs_test_import = booksdb.OpenRecordset(&quot;tes<wbr />t_import&quot;,<wbr /> dbOpenDynaset)<br />
<br />
I am getting the type mismatch on the last line.
</div>
</div>


I have the following code that I swear was working. Now I get a type mismatch error. Can anyone shed some light on this..

Dim rs_test_import As New Recordset
Dim booksdb As Database

  Set booksdb = OpenDatabase("books2.mdb")
  Set rs_test_import = booksdb.OpenRecordset("test_import", dbOpenDynaset)

I am getting the type mismatch on the last line.

Another Simple Database connection

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.