Kevin I did what you suggested. I placed the code in the form load just before the call to the table adapter and as soon as I got the path correct was able to open the correct database. Worked like a champ. Thanks a lot.