Hi,
I wan't to execute sql statements on the SQL Server in local intranet using outlook VBA Code.
Same in VB is done using ADODB Object but how to go about in VBA??
User Profile
Collapse
-
Executing SQL in outlook VBA
-
HI Jamesh,
First make practice of keeping the database(*.mdb) in the path where ur project files exists and use app.path\*.mdb to access it.
then copy the database along with the projectfiles in any system it will work.
If you are creating a setup package using package and deployment wizard, you'll have to include the database file along in the setup(option will be available while creating the setup)....
No activity results to display
Show More
Leave a comment: