Trying to get DOA Access into MS Project with VBA

[Spacebound]

hi guys, hopefully an easy one. Am I being stupid here or what - using the normal DOA variables in MS Project doesn't work. In other words I can't open a DOA object via "Dim myobject as Database" or TableDef or RecordSet or anything else listed in the DOA references. Anyone know how I can just plain open the Access Database table, get some sums from the fields and plop them into variables in MS Project.

Thanks
Dave

 

[Spacebound]

Sorry -- of course I meant DAO -- Data Access Object. Declaring variables in MS Project is my problem.