Dim as Database returning an error

[mdweezer]

Using a simple

Dim foo as Database

is for some reason returning the following error:

User defined type not defined

it however was working, what would trigger such an error?

Thanks

 

[CajunCenturion]

Your default data model for that application must be ADO. Therefore, to use the DAO objects, you need to include a reference to the latest DAO objects.

Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Dimandja]

Yeah, go to the References window - under the VB window - and checkmark your Microsoft DAO.

 

[PHV]

And don't forget to properly define your recordsets:
Dim rs As DAO.RecordSet

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244