Northwind example does not work? (!)

  • Thread starter Thread starter chris.english
  • Start date Start date
C

chris.english

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
 
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'
Click to expand...

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.
 
Back
Top