auto link from Project 2000 to Access database

[jt]

Is there a way to create a Project file that links to an Access
database automatically? I've tried out the import data feature, but
it requires the user to select a map each time the Project file is
open. I also don't want to write a small external procedure that maps
it to the database. I just want to know if there is something you can
set up within Project that would link it to the Access database when
the user opens the file from a public folder directory. Thanks.

-jptu

 

[Rod Gill]

Hi,

No. There is no DDE functionality in Office to Database records in Access.
However, you can save projects in any ODBC database (Including Access) and
update data in that database. This is then reflected when opening in
Project. However, you have to be careful and specific when editing the
database. Digest THOROUGHLY Projdb.htm: it's stored in one of Project's
program folders.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/