calling access vba function from asp?

Dear all,

I have an asp module connecting to a MS-access database.
I have a vb function MKDate(date, time) in a vba module of this
database.

I would like to query :
SELECT MKDATE(col1, col2) FROM TABLE1

(real query is complex, using unions, etc, but I need one column in
resultset)

But I get an error opening the recordset
"Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Undefined function 'MKDATE' in
expression.
/selfmail/dossier.asp, line 729"

I also tried to copy the code of the function MKDate(date, time) inside
.asp module, no change.


Is it possible to call a vba function inside an asp sql statement?

Regards,
Alain

Bob
Tue May 06 17:24:01 CDT 2008

Alain Bourgeois wrote:
>
> Is it possible to call a vba function inside an asp sql statement?

No, it is impossible to call user-defined VBA procedures from any
external application, including asp. It's been a thorn in our sides for
years. You will need to find another way to accomplish your task.

For this specific purpose, you don't need a user-defined function.
Without knowing the datatypes of col1 and col2, I cannot be specific,
but I'm sure you can do this conversion in your query without a
user-defined function.


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.