VBA, How to Use Access module functions via VB app with ADO

How to Use Access module functions via VB app with ADO

Author	Message
Russ Mot #1 / 2	How to Use Access module functions via VB app with ADO I have created several public functions in an Access 2000 VBA module that are the equivalent of the Oracle PLSQL datetime functions (Round,Trunc,Add_Month...). If I create an Access Query using these functions the Query is successful when run from inside Access. However, if I write a VB program using ADO and the Jet 4 provider and try to execute this Query...ADO returns a error that my custom functions are not defined. How do I make these functions available to the external world?
Wed, 08 Sep 2004 06:32:10 GMT

david #2 / 2	How to Use Access module functions via VB app with ADO You can't. The functions are stored inside an MDB/MDE and only Access understands how to find and use them. Furthermore, only Access has the query interpreter that interprets imbedded user defined functions. The equivalent functionality is SQL Server works quite differently. (david) Quote: > I have created several public functions in an Access 2000 > VBA module that are the equivalent of the Oracle PLSQL > datetime functions (Round,Trunc,Add_Month...). If I create > an Access Query using these functions the Query is > successful when run from inside Access. However, if I > write a VB program using ADO and the Jet 4 provider and > try to execute this Query...ADO returns a error that my > custom functions are not defined. How do I make these > functions available to the external world?
Fri, 10 Sep 2004 08:46:07 GMT

Page 1 of 1

[ 2 post ]