Simple Declaration Question

[Gartz]

I was wondering what the correct variable type would be within the declarations section for the following variables:

************
Set DB = DBEngine.Workspaces(0).Databases(0)
***********
Set Table = DB.openrecordset("Registered Students Table", DB_OPEN_DYNASET)
************
I'm pretty sure the "Table" variable is Dim Table as Recordset but what is the "DB" variable??? Is it Dim DB as Connection????

[Gaffer]

Dim db as database

This is DAO...

[Gartz]

I know that what you are saying should work but for some reason it does not......I keep getting a "User defined type not defined" error when "On_Current" and "On_Load"........I really don't understand what the problem is, it should be exactly what you said.........It works fine if I leave both variables as "Variant" but of course that is bad programming. Thanks for all your help

[JoshT]

Make sure your reference is set to DAO, and there's not one set for ADO.

[Gartz]

Thanks for all your help....It works now........I added the reference to MS DAO 3.6 Object Library and removed the reference to MS ActiveX Data Objects 2.1 Library.......I am assuming this is correct now that it is working. If it is still wrong please let me know. Thanks again!

[JoshT]

You doing this with Access 2000 / VBA? I believe it defaults to having the reference for ADO checked, which can cause confusion if you add DAO, because of similar object names. Since you have it working you should be all set.