I'm looking for some helpful hint on how to create and
manage a project in Project 98.  I want to store all of
the data within Access and have a function that will
automatically create or modify an new or existing project
using VBA.  I can reference the dll in Access but I can't
seem to find any code that will allow me to work with MS
Project 98 within MS Access 97.  Can anybody help?

Derrick,
Although I've never worked with an Access database, you can open an
Access database in Project. Follow these steps (they are pulled right
out of the Project 98 Users guide. I assume they are also detailed in
the help files but I haven't looked):
1. Go to File/Open
2. In Files of Type list box select "Microsoft Access Database"
3. Select your Access database file
4. Click Open, click Selective Data and then New Map
5. Under Data to import, select the check boxes for the types of data
you want to import
6. Click the tab for the type of data you want to import. For example,
if you slected the Tasks check box, click the Task Mapping tab
7, In the Source database table name box, click the table name from
which you want to import. Project fills the From column with all the
fields from the table. Any table field that matches a Project field name
will be matched to the Project field automatically.
8. For any unmapped field in the TO: Microsoft Project Field column,
select or enter the Project field that you want to map to the
corresponding table field from Access
9. In the Method for incororating improted data box, click an option
10. To save the map, click OK

This should get you started.

John

Derrick,
Sorry, after I replied with all the manual steps on importing Access
data to Project, I re-read your post and realized (Duh) you were asking
for an automated way to do it. I have not done any VBA from Access but I
have done macros to transfer data between Project and Excel. If you
don't get another answer, I would be happy to help you automate the
process with a macro run from Project to pull the data from Access.

John