0
00090
Hi everybody,
I have an access DB (version 2000) with several queries like:
insert into table1 (col1) select myfct(col1) from table2
As you can see, the query includes a VBA function (myfct) stored in the
module of the database.
When I try to execute the query from within VB, I get the error saying that
the function is not found.
I check this problem on the internet and find this error is normal but not
the way to solve the problem.
If I cannot execute the query from an ADO connection , How can I ask
Access (via OLE or DDE perhaps ? ) to execute it for me ?
many thanks for your help
I have an access DB (version 2000) with several queries like:
insert into table1 (col1) select myfct(col1) from table2
As you can see, the query includes a VBA function (myfct) stored in the
module of the database.
When I try to execute the query from within VB, I get the error saying that
the function is not found.
I check this problem on the internet and find this error is normal but not
the way to solve the problem.
If I cannot execute the query from an ADO connection , How can I ask
Access (via OLE or DDE perhaps ? ) to execute it for me ?
many thanks for your help