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 |
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 |
All times are GMT +1. The time now is 02:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com