How to convert an ADP project under source control from Access 2000 to Access 2003?
We have an ADP project created several years ago using Access 2000. This project i开发者_如何转开发s under source control (using the Access' standard MSSCCI-based add-in that integrates Access with SourceSafe).
Now we use Access 2003 to work with this project. Everything seems to be working okay, including integration with source control. However, when this ADP file is opened by Access 2003, it says that the project has "Access 2000" format.
Assuming that there are some good reasons to convert this ADP project from "Access 2000" format to "Access 2002-2003" format, the question is:
How exactly can I perform such a conversion without "losing" source control (in particular, without losing all the source change history)?
After certain amount of research across multiple information sources, I've found the following solution:
Open the ADP file (e.g. MyProject.adp) in MS Access, as usual.
Check out everything.
Use MS Access menu (Tools >> Database Utilites >> Convert Database >> ...) to convert the ADP file to "Access 2002-2003" format (e.g. using MyProject_New.adp as the name of the new file). (IMPORTANT: Answer "NO" to the Access' suggestion to remove the project from source control.)
Close the old ADP file and replace it by the new ADP file.
Change the Access' default file format (Tools >> Options >> Advanced) from "Access 2000" to "Access 2002-2003".
Open the now overwritten ADP file.
Check in everything.
精彩评论