>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)?
Yes. That is the problem.
You must put somewhere in INI file or in some Table the fullpath to the MDB and allow the user to cahnge it. Then you can recreate your connection with just change the DataBase name.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.