 |
jfletcher77055 Level: Protégé
 Registered: 03-12-2008 Posts: 4
|
Problem with OpenRecordSet
I have tried everything I can think of and now I must give up and post a question. I have some simple code that worked fine when I set it up in Access 2003, but does not work in the version I converted into Access 2007. Here is the code:
Dim db1 As Database
Dim rs1 As Recordset
Set db1 = CurrentDb
Set rs1 = db1.OpenRecordset("Overby_Seawall_Non_DUPLEX_Files")
I get a 13 Type Mismatch error on the OpenRecordset.
I have another application in which I am opening a recordset using a query. In that case I set the type to dbOpenDynaset. It works properly. I have compared the references in both of these applications and they are the same. I have tried both dbOpenDynaset and dbOpenTable with this one and it still gets the same error. What to do?
|
|
14-04-2009 at 08:37 PM |
|
|
|
|
 |
 |