Is it possible to call code in Access using DAO?
Colin:
No you can't call code directly from DAO. If you run a query (aka command
in ADO) which contains a call to a function in the db, and the function will
run as part of the query. If you are using asp, you could instantiate an
access object and then use the RunCommand method of that object to execute
code, but this incurs lots and lots of overhead on the server and is
impractical, especially if you have many users banging away at one time.
Rather build your code into the ASP code (or cgi etc.) that you are running.
HTH
Steve Arbaugh
ATTAC Consulting Group
http://ourworld.compuserve.com/homepages/attac-cg/acgsoft.htm
Quote:
>Does anyone know if it is possible to call code from an access module using
>DAO?
>I need to execute code in an Access database from the web.
>Any ideas would be appreciated?
