HowTo: Move DataBase

[Ariadne]

Hi, I had to move a MSAccess Database to a new location. In VS2005: Is it possible to change the path only without recreating all queries and tableconectors etc.? Thanks!

Ariadne

[Ashfield]

It should be, your connection string defines the path to the MDB, all the queries etc are running on the connection.

Bob Ashfield Consultants Ltd

[Abhijit Jana]

Ariadne wrote:

I had to move a MSAccess Database to a new locati

so, you have just move the MDB file, then you dont need to change in any query or table etc. just change the DBpath in connection string . Thanks

Best Regards ----------------- Abhijit Jana Check Out My Latest Article Java.NET : Integration of Java and .NET[^] "Success is Journey it's not a destination"

[Ariadne]

Abhijit Jana wrote:

just change the DBpath in connection string

is there a usual way in VS2005? I tried to change all occurrences of the old DBPath into the new one. But VS allways looks at the old path.

Ariadne

[Ariadne]

one has to compile the project! Then the DB-Path is changed... And if you want to use the new DB-Path in your xsd DataSet (eg. Data Preview) you have to restart VS. Thanks

Ariadne

modified on Thursday, June 26, 2008 5:57 AM