How to convert an ADP project under source control from Access 2000 to Access 2003? -


We have an ADP project that was created using Access 2000 several years ago. This project uses source control (Access Standard MSSCCI based add-in that integrates access with SourceSafe)

We now use Access 2003 to work with this project. Everything is working fine, which includes integration with source control. However, when this ADP file has been opened from Access 2003, it says that the project has the "Access 2000" format.

There are good reasons to change this ADP project from the "Access 2000" format to "Access 2002-2003" format, the question is:

How OK can I make such a conversion without losing "source control" (especially, without losing all source change history)?

After some research on more than one information source, I found the following solution:

  1. Open the ADP file (such as MyProject.adp ) in general, in MS Access.

  2. See everything .

  3. To access the ADP file in the "Access 2002-2003" format, go to MS Access Menu ( Tools> Database Utilities> Convert Database ... ... ) such as MyProject_New.adp as the name of the new file). ( No answer for "access" suggestions) to remove the project from source control.

  4. Close Old ADP file and replace it with new ADP file.

  5. Change access' to 'Access 2002-2003' from the default file format ( Tools >> Option >> Advanced ) "Access 2000"

  6. Now open the overwritten ADP file.

  7. Check in everything .


Comments

Popular posts from this blog

MySql variables and php -

url rewriting - How to implement the returnurl like SO in PHP? -

Which Python client library should I use for CouchdB? -