See:
http://www.mvps.org/access/bugs/bugs0031.htm
Bugs: Access 2000: Type Mismatch or User Defined Type Not Defined
Author(s)
Dev Ashish
When you create a new database in Access 2000, the default data
access library used is ADO. That is, ADO will be selected under
Tools/References in VBE instead of DAO. Converted databases still retain DAO
as the default library and ADO will not be selected under References.
The "Type Mismatch" error occurs as the global class Recordset is
evaluated as ADODB.Recordset instead of the DAO.Recordset, while the "User
Defined Type Not Defined" error is generated at compile time because there
is no Database object in ADO.
To fix this problem, uncheck the ADO reference and check DAO 3.6
Library as a new reference.
You may still receive this error message when referring to DAO
Recordsets if you have both ADO and DAO selected under References. This is
because the ADO reference is listed above DAO in the References dialog and
hence, is taking precedence at runtime when Access tries to resolve your
data types. To move the DAO reference above the ADO one in the dialog,
a.. Uncheck the ADO reference.
b.. Close the References dialog.
c.. Open the dialog again.
d.. Check the ADO reference.
e.. Close the dialog.
If you are working with a database in which both ADO and DAO
references are selected, the best way is to always fully qualify your data
types. For example:
Dim rsCustomers as ADODB.Recordset
Dim rsInvoices as DAO.Recordset
For more details on which references to use in your application, view
this article.
Article ID: 197110
ACC2000: References to Set When Working with Microsoft Access
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
<Ti*****@gmail.com> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...
I tried the Module available for doing this at the AccessWeb site below
(using Access 2000)
http://www.mvps.org/access/modules/mdl0008.htm
but, unfortunately, I get either a "Complie Error: User-defined type
not defined".
I really need something similar myself, but can't figure out what I
need to fix.
Tino