Yes, you need to identify the correct path somehow in the configuration file or in the program, and you need to rewrite the connection string after that.

>From the Project Manager, Data tab, there is a Connections line. This is what I used to create the connection.
>
>Under Specify Data Source, I checked Data Source, userid, password.
>
>I changed this to Connection String and specified the string which eliminated the Select Database dialog.
>
>I noticed that the connection string has very specific directory names corresponding to my development environment and not the same as the user environment. Will this cause a problem when sent to the user (i.e. cannot find the database because the directory specified does not exist)?