Help on DAO object problem
When using DAO object for to access MDB database I get errors. It's clear because something has to be included (imports) or added reference to my prog. For example:
Dim dbMyDB As DAO.Database
Dim oDBEngine As DAO.DBEngine
Dim rsMyRS As DAO.Recordset
dbMyDB = oDBEngine.OpenDatabase("...\MyMail.mdb")
rsMyRS = dbMyDB.OpenRecordset("Users", dbOpenDynaset)
I got: Name 'dbOpenDynaset' is not declared
If I write:
Dim dbMyDB As Database
dbMyDB = OpenDatabase("...\MyMail.mdb")
I got: Type "Database " is not defined.
Name "OpenDatabase" is not declared.