dim mydb as database

[Jeff Wimer]

I have used dim mydb as database in on database and it worked fine. Now I
have created a new database on the same machine that uses linked files from
the first, and the dim mydb as database does not work. It errors out with
user-defined function not defined. Any ideas?

 

[Marshall Barton]

I have used dim mydb as database in on database and it worked fine. Now I
have created a new database on the same machine that uses linked files from
the first, and the dim mydb as database does not work. It errors out with
user-defined function not defined.

In A2000 and A2002 ADO is the default data library. Review
your References (Tools menu from any code module) and Check
DAO to use the Database object. If you don't intend to use
ADO, uncheck that reference.