calling access vba function from asp?

[Alain Bourgeois]

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 Barrows [MVP]]

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.

[=?Utf-8?B?V2Vz?=]

I don't have ASP setup to try it, but what if you make a Query in Access
which internally calls the vba code & then call that from the ASP?

such as
MyTestQuery =
INSERT INTO TableName(col1, col1, col3) VALUES( @param1, @param2,
MyFunc(@param1,@param1) )

in ASP:

Dim connStr
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=" & Server.MapPath("MyDB.mdb")

' Connection Object
Dim con
Set con = Server.CreateObject("ADODB.Connection")

' connecting to database
con.Open connStr
' executing stored procedure
con.Execute "exec MyTestQuery 'valu1', 'value2', 'value3', 'value4' "

' closing connection and freeing resources
con.Close
Set con = Nothing
Would this work ?

"Bob Barrows [MVP]" wrote:

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.

[Bob Barrows [MVP]]

Wes wrote:

I don't have ASP setup to try it, but what if you make a Query in
Access which internally calls the vba code & then call that from the
ASP?

It won't work. BTDT.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"