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)?