ASP page to run MS Access function??

[Samoyed]

Hi,

I currently have a function stored in the modules tab in my Access 2000 database. To test it, I just call the function during the OnClick event of a button on a form.

I know you can connect to the database through an ASP page by using ADO. What I'd like to know, if its possible, can this function run when triggered by an ASP page after they click submit on that ASP page?

If so, can you show me some sample code on how that function is going to be called? Or perhaps there may be another way that would be more efficient?

Any ideas would be greatly appreciated.

Thanx in advance

Kevin

 

[codestorm]

in my experience you can only interact with access table and query objects - but hey, i'd love to be proven wrong.

don't you hate it when your shift key is broken codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>

 

[vanillapod]

Hey I'd looove to do that to but I've always been told it can't be done without actually opening an instance of the database which I don't want to do.... hope you manage to do it though