Automation of MS Project with MS Access

[karassik]

Hello,

I am having trouble automating MS Project 2000 with MS Access 2000. I have had no trouble whatsoever with automating Excel.

Here is the Code I'm using:

Dim prjApp As MSProject.Application
Dim prjProject As MSProject.Project

prjApp.Visible = True

Set prjApp = CreateObject("MSProject.Application&quot

Set prjProject = GetObject("G:\data.project\new\mold.mpp","MSProject.Application&quot

prjProject.AcceptNewExternalData = True
'Set WBS Code for whole project
prjProject.Application.WBSCodeMaskEdit (Me.JobNumber)

'Set Task Names
prjProject.Tasks(0).Name = Me.JobNumber

It goes on to set all the tasks and their durations. When I run this code from Access, I get a "File name or Class name not found during automation operation", Error.

If anyone has any suggestions, please help. I feel like I'm overlooking something simple here.

Nishan