Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run An MSAccess VBA Function From Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run An MSAccess VBA Function From Excel
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Start Excel inside MSaccess with a makro | Setting up and Configuration of Excel | |||
using linest excel function from msaccess with multidimensional ar | Excel Worksheet Functions | |||
Shell to MSAccess | Excel Programming | |||
Shell to MSAccess | Excel Programming | |||
Shell to MSAccess | Excel Programming |