Run An MSAccess VBA Function From Excel

[Frank]

Hi I am working on a network that don't support creating an Access object I
can't shell because the jet is 98 and our databases are 2000, is there a way
to run the code using ADO or DAO I can Create new instance of MSAccess from
my desktop but I need to run the code on the network any ideas??.
TIA
Frank

[K Dales]

What is it you want to do, Frank? ADO allows you to pass commands to your
Access database in SQL, so if what you need to do can be done in SQL you
should be able to use ADO. That would mean (assuming you have full access
rights to the database) you can do pretty much anything you want with the
tables, including changing their structure - but SQL won't give you any
ability to manipulate the Access application itself; e.g. showing forms or
running reports, etc.

"Frank" wrote:

> Hi I am working on a network that don't support creating an Access object I
> can't shell because the jet is 98 and our databases are 2000, is there a way
> to run the code using ADO or DAO I can Create new instance of MSAccess from
> my desktop but I need to run the code on the network any ideas??.
> TIA
> Frank