
User-defined type not defined (Access 97)
Quote:
>I have a module where I am trying to use the Database and Recordset
>objects. But when I type
>Dim Db as Database
>Dim Rst as RecordSet
>I get the error message "Compile error: user-defined type not defined"
>As I'm basing my code on stuff I found in Litwin, Getz and Gilbert I'm
>puzzled as to why I'm getting the error message. (However I am a complete
>newbie to Access...!) I use Access 97 on Windows 2000 SP3.
You'll have to add a reference to the DAO library (tools
menus while viewing any code module). From your question, I
think it's safe to assume that you're not intending to use
the ADO library, so uncheck that reference.
--
Marsh
MVP [MS Access]