Changing the connection string in VB2005

[drimades]

I used the wizard to create a connection to an Access db. With this connection I created some datasets. Now I have moved the database file (.mdb) to another directory in the system. How can I change the connection string to point to the new location?

 

[SgtJarrow]

When you created the connection via the wizard, there should have been a checkbox asking if you wanted to save this connection. If you checked it, then the connection is stored in the Settings for the project.

In the Solution panel right-click the project name and select properties. Click on the Settings tab. There you should find your connection. Just modify the Value field and everything should be golden.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer