Opening a dynaset-type recordset
Posted on 2003-03-25
I want to open a dynaset type recordset so that I can use the find methods (a table type recordset won't work for my purposes). I have the following code run from a form:
Set cert_rst = CurrentDb.OpenRecordset("Cert_Log", dbOpenDynaset)
When I try to run the code, I get the message 'runtime error 3001: invalid argument'. Cert_Log is a table in my database and it is spelled correctly. I have used almost the exact same code in a different database with no problems. That code looks like this:
Set props_rst = CurrentDb.OpenRecordset("Props", dbOpenDynaset)
The only difference between the 2 databases is that one of them is linked and has a front and back end and the other is not linked. The one that is not linked is giving me the error message. So I tried adding a linked table to that database and opening it as a dynaset. I got the same error message.
In the non-linked database, it lets me open a table type recordset only if I use the default and don't specify the type. If I add the argument 'dbOpenTable', I get the same error message. Any ideas??????