[AccessD] DAO and ADO problem =>urgent!

On 12 Aug 2003 at 23:13, Sad Der wrote:

> Hi group,
> 
> i've got a big problem. I've created a certain
> 'general access solution' that I've implemented in a
> lot of applications, works like a charm.
> 
> ....until I came to this DAO app! The solution I
> created is all ADO.
> 
> When I reference ADO, so I've got DAO and below it in
> the reference field I've got ADO, the app doesn't run
> anymore. However it DOES compile?! When i run the app
> It doesn't get lines like:
> Set db = CurrentDb()
> 
> PLEASE TELL ME THAT I CAN USE DAO AND ADO OR I'M IN
> BIG TROUBLE!
> 
If you have both ADO and  DAO referenced, you have to explicitly DIM 
it as the correct type or it is likely to use the wrong reference.

Try Dim db  as DAO.Database







 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.