Converting Project 2003 MDB File to Project 2007

[Augie Bez]

I have recently taken over an MS Access based program and I have a problem.
I want to convert my MS Access 2003 Project MDB file to MS Access 2007 ACCDB
file. MS Project 2007 did not like it when I tried converting the Project
MDB file using MS Access 2007 to an ACCDB file. I get “Project does not
recognize this file format†error message when using MS Project 2007 to try
to open the newly converted ACCDB file.

How can I convert my 2003 Project MDB file to MS Access 2007 ACCDB file
where MS Project 2007 will recognize it? The 2003 version of project
contained a file named, “C:\Program Files\Microsoft
Office\Office11\1033\PJDB.HTM†which helped with the conversion. I do not
see this file for MS Project 2007. Also, using MS Project 2007 to open a MDB
Project file in MS Access 2003 format results in opening a project in “Read
Only†mode (I thought that maybe I could just leave the MS Project file in
the old format).

Scanning the web I read that Project 2007 no longer supports saving to ODBC
databases. Is this true? Even for Project Professional? If this is true
then:

1. Can I upgrade to MS Office 2007 except for Project (Keep Project
Professional 2003) and keep the Project database file as an MDB file.

2. I want to be able to keep all of the “Project Schedules†together (don’t
have a bunch of individual .MPP files). Does this mean I should eventually
go to Project Server? If so, does this just require SQL Server (which we
have)?

 

[JulieS]

Hello Augie Bez,

Re:

Scanning the web I read that Project 2007 no longer supports
saving to ODBC
databases. Is this true? Even for Project Professional? If this
is true
then:

Yes. Project 2007 no longer supports saving the ODBC databases.
Even for Project Professional.

1. Can I upgrade to MS Office 2007 except for Project (Keep
Project
Professional 2003) and keep the Project database file as an MDB
file.

Yes. I believe there are several users who use older versions of
Project with newer releases of the Office Suite.

2. I want to be able to keep all of the "Project Schedules"
together (don't
have a bunch of individual .MPP files). Does this mean I should
eventually
go to Project Server? If so, does this just require SQL Server
(which we
have)?

Project Server requires a bunch of other software to support it,
including SQL Server. For details on other requirements I suggest
taking a look at Microsoft's site for the required software/hardware
for Project Server. If you have questions specific to Project
Server, post to the Project Server newsgroup.


I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project