Hi!

I have some code like this:

dim set1 as recordset, set2 as recordset
Set set1 = MyBase.OpenRecordset("qQuery1", dbOpenSnapshot)
set1.Filter = "Type=3"
Set set2 = set1.OpenRecordset(dbOpenSnapshot)
...Update some variables in a table that qQuery1 uses, that's why I use snapshot on set1 and set2, so they are frozen at the time of query...
set2.MoveFirst
set2.MoveNext

And on the last line here I get an error message: "Unknown function name" on MoveNext. But I can't see why! I think this should be legal! Any tips greatly appreciated!

Yours sincerely

Knut Hunstad

Make sure all your reference libraries are open, e.g. DAO 3.6.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Check to make sure your recordset count is <> 0

Sal

Thanks for your suggestions! Unfortunately, I don't think they apply to me...

As far as I can see, I have all necessary libraries (including DAO 3.6) referenced (or what do you mean by "open"?). BTW, this is a program that has worked for a long time, except I changed the query a bit, so I can't quite believe it's a library problem.

And although I let it out in my example code, I always check for EOF before applying MoveNext, so I don't think checking the RecordCount would help either (the first record achieved by MoveFirst is OK, it's the MoveNext that gives the error).

Hello again!

This problem seems to have been an error that is corrected in SP8 of the Jet Engine (which came yesterday, I think!). At least, after running Windows Update and installing this update, everything is OK! I was already getting more or less determined that this must have been an error in Access/Jet or something outside of my software, and it seems I was right (this time).

Thanks to you both for trying!

Yours sincerely,

Knut