How to call a code module function from the website?

[Yelena Varshal via AccessMonster.com]

Hello,

I have a code module in Access 2000 that is performing an action. I would
like to call this code from a website or in general from any ADO-compliant
front end. Could I do it directly similar to how I call a query using ADO or
the only way is to create an instance of MS ACCESS object?

Thanks in advance,

 

[Alex Dybenko]

hi,
from website - you can use createobject() to create access instance on a
same PC and then open mdb and run function you need.
Also you can consider use .NET webservices or ADO RDS, to access mdb tables
over HTTP

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Yelena Varshal via AccessMonster.com]

Thanks Alex!

I will probably use a createobject() solution. While WebServices is a very
good idea too, this particular function will be used only once in a while by
the application administrators to work with a user list. So it has to have a
nice (very nice) user Web interface but the usage will be low, so we don't
need to think about the performance.

visit www.sqlservercentral.com for the SQL Server forums, questions get
answered there including a forum on MS ACCESS connection to SQL Server

Yelena

hi,
from website - you can use createobject() to create access instance on a
same PC and then open mdb and run function you need.
Also you can consider use .NET webservices or ADO RDS, to access mdb tables
over HTTP

Hello,

[quoted text clipped - 5 lines]

Thanks in advance,