openrecordset error

[Guest_imported]

using access 2000 and attempting a very simple piece of code
such as

dim db as database
dim rs as recordse
set db = currentdb
set rs = openrecordset("pupils&quot
rs.close

I get the error message 13 type mismatch
what's going on?
I've 'hatched' the DAO library in tools/references
Is it a problem with VB for applications not being 'hatched' or is it a problem with 'ADO'

please help a former COBOL programmer, now a science teacher

 

[Databaseguy]

Yesh, diff between 97 ad 2000. Easy fix, make ref to DAO3.6 in tools/references and move it "up the ladder" using the arrows.

Better, see my page. Follow the 97 vs 2000 link. It'll show you how to properly construct ADO code. Also, visit this site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/daotoadoupdate.asp

Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy