Access compatibility with Project 2007

[Tito]

According to the supported file formats posted at the site below, MDB files
can only be read but not created from Project 2007. I have Access users who
won't migrate to 2007 because they are heavy Access users and need to create
MDB files from Project.

http://office.microsoft.com/en-us/project/HA101324981033.aspx

Is there a workaround for this?

One other thing to note - we're in the process of transitioning to Project
Server 2007, I'm thinking we should be able to support their reporting
capabilities from PWA but I wanted to know what my options are.

 

[Rod Gill]

Hi,

Project 2007 cannot save projects to .mdb files but VBA macros can save any
data you want to any ODBC data source using OLEDB. I have a macro I'm
developing that does this. Not all data is saved, but all data required for
reporting is. Original data is saved in .mpp files (or in your case Project
Server).

However with Project Server, your users may easily be able to swap to
reporting from the Reporting database in SQL Server.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Tito]

Thanks for the quick feedback Rod!

Hi,

Project 2007 cannot save projects to .mdb files but VBA macros can save any
data you want to any ODBC data source using OLEDB. I have a macro I'm
developing that does this. Not all data is saved, but all data required for
reporting is. Original data is saved in .mpp files (or in your case Project
Server).

However with Project Server, your users may easily be able to swap to
reporting from the Reporting database in SQL Server.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com