[AccessD] Calling ADO without having to roll out five hundred new mdbs

Mark Breen marklbreen at gmail.com
Mon Jan 17 05:57:48 CST 2005


Hello All,

I just sent an email tell you about a new project that I have taken
on.  It is Access 97 and Oracle as the BE.

We would like to use ADO for some stored procedures to avail of output
parameters, but it is not desirable to have to reference ADO on five
hundred PC's.  Especially with different versions of the OS throughout
the company.

Is there a way that I can call this ADO, from a central database and
pass the results back to the clients that are located throughout the
company?  Maybe MDA's?  I know that if I use MDA's that I will have to
reference them, but that might not be too bad because at least I can
control the version.  But that MDA will need the ADO reference.

I have not really done any COM / DCOM work, but maybe some of you have
and can think of a solution to this,

The alternative is to try to rev the access db with new references to ado.

Thanks in advance for your help.

Mark



More information about the AccessD mailing list