How to access a SQL job or package from Access

[fmientjes]

Can someone help me with the rigt vba code for starting a job or a local package within SQL-server?

I have made a local package and from that package I created a job.
I would like to start the local package or the job from Access.

Frans

 

[tortoisehalfbreed]

If you have enterprise manager on your computer, hook up the reference to the Microsoft SQLDMO Object Library. I can't give you any specific code, I just know that a guy that worked for us used it in an asp page (vbscript) to automate the backups of our SQL Data.

Have a scout around on the microsoft site for methods and that.

(I know you should start off something like this...
Dim oSQL As SQLDMO.SQLServer
oSQL.Connect
)
Hope this helps any

 

[Craig0201]

You don't need Enterprise Manager, just the SQLDMO libraries.

 

[vbajock]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba01/html/ManagingSQLServer.asp