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,

--
Regards,
Yelena Varshal

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...dules/200604/1

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" <u15452@uwe> wrote in message
news:5f463855a4b56@uwe...
> 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,
>
> --
> Regards,
> Yelena Varshal
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200604/1

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




Alex Dybenko wrote:
>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,

--
Regards,
Yelena Varshal

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...dules/200604/1