Use Access Variables from ASP

[Si]

Hi Guys

I want to check the value of a VBA variable within Access from an ASP page.

I was wondering if anyone knows how i can do this.

For a little background on the problem, I need to check whether a function
in VBA is running, so that another user does not concurrently execute the
function again from an ASP page. The boolean variable that i want to access
says True when the function is running.

Thanks for any help in advance

Si

 

[Michael]

Why not create a table in Access with one Yes/No field.
Your VBA code could change that field as needed and your
ASP page simple checks the value in that table to see if
your VBA code is running. If you had several varibles you
needed to check, you could create seperate fields for
each of them in the same table, set them as needed and
read them from ASP. Your ASP page could also reset them
to other values that you VBA code could use.

Hope this helps,
Michael