Hey all.

I have a VB program that links to a database using ADO. I'm not coding my connection string just using the properties dialog box. Under the connection tab I just have the name of the database not the full path . I do this because some times I use a different computer or move the application folder. My problem is that I have a menu command that opens up a common dialog box to choose a wave file. The wave files are in a folder in the application directory. When I do this it causes the connection to look in the wave folder and of course the DB is not there. I guess since I just have the name of the DB in the database field it doesn't know exactly where to look and just looks in the last folder accessed. Is there a way to force it to use a relative path (I have done this in other sections of my program with App.path & "file name") in the properties dialog box??

Sorry for the confusing post. Hope someone understands this and knows the answer.