I've been having some trouble opening a database object with A2K and
couldn't work out why (tried Dim db As DAO.Database and Dim db As
Database). I just kept getting 'Compile error: User defined type not
defined'

Database object user defined? Hmmm so I copied a northwind example
(Function HideStartupForm()) and it does the same

Please help! It's driving me nuts

Chris E

john vinson

Access 200x default to the newer ADO object model - the DAO library is
not selected by default.

Open the VBA editor and select Tools... References. If you're not
using ADOX, uncheck the Microsoft ActiveX Data Objects library
reference; in any case scroll down to Microsoft DAO Object Library
x.xx (highest version, usually 3.51 or 3.6) and check it.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public