Access not recognising functions upon conversion to 2000

[rorymurray]

When I converted my database from 97 to 2000, everything worked, except for the objects that use functions. If I use either a built in function, such as Format(), Left() etc, or one I wrote myself, Access says it doesn't recognise the function .....

Any ideas?

 

[ToeShot]

By Default Access 97 uses the DAO Object Library in Access 2000 it uses the ADO object library by default. Just check your references, that should fix your problem.

HTH Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait

 

[rorymurray]

Thanks for the reply.

how do I check my references?

 

[ToeShot]

in your VBA editor go to tools then references. The scroll down and select the Microsoft DAO 3.X Object Library then with the scroll arrows next to the selection box. Move the priorty up to the top untill it sits above the Microsoft ADO 2.X Object Library.

HTH Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait