Dim db as Database Missing

[Zine]

On MS Office for educatiors in a Client Environment has
Microsoft not included Dim db as DAO.Database or Dim db as
ADO.Database or Dim db as Datbase been excluded?

Thank You in Advance

Tony Zine

 

[Perry]

I don't have any experience with MS Office for Educators but
what I can tell is:

1)
Dim db as ADO.Database
is certainly not supported by MS
There's no ADO 'namespace' pointing the ADO library
You will likely mean:
Dim db As ADODB.Database
but this won't work either because Database is not an object
under the ADODB library.

For more info on usage of ADO, look here
http://msdn.microsoft.com/library/default.asp?url=/code/list/ado.asp

2)
Dim db As DAO.Database
In MS Office Professional, this is a regular expression and fully
supported provided the reference pointing the DAO library in VBE
is set.
In VBE, menu: Tools | References

3)
Dim db As Database
From Office 2K (Professional) onwards, this statement is likely to
cause an error.
DAO is not the default database connecting interface from Office 2K onwards.
You will have to set a reference to the DAO library and use
the declaration style as used in 2)

Krgrds,
Perry