Hi
I have forms where I have used the "Add New Data Source" and then follow the panels and make connection and create my project.

If I run on another computer or move the database to another drive I get an error "connectionstring G:....." not found (or similar). That is is true I have moved the data source from one drive to another.

What is the best way to change it.

I can do it by editing the VB 2005's project XML files but this seems a bit error prone - is there no way - or must I write a program to do it!

__________________
Pat

Hi How I got around this problem.

This is a problem in testing when testing on different PC's.

To get around this I put my database in the home folder - the folder that contains the bin file. Then I seem to be able to move the project about.
If you reply yes to copy to project folder (bin/Debug) then it will be the (bin/Debug) version that is updated and the original in the home folder remains unchanged - next time you run the version form the home folder (the unchanged version) gets copied to the bin/debug folder.
If your reply no to copy to project folder the version in the home folder will be updated, so needs backing up.

__________________
Pat