Northwind example does not work? (!)

[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

 

[John Vinson]

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'

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.

 

[Chris]

Shame we can't have a sticky for this.

 

[John Vinson]

Shame we can't have a sticky for this.

I do: refs.txt in my Agent "insert file" folder.