Problems With Connecting To Database

I have a MS Access database I'm trying to connect to. I can connect to it but it won't connect nicely. I can only connect to it if I use an absolute path. I would like to connect to it either by using a DSN or a relative path. It's seems unreasonable to even consider assuming the Access database and application are going to be installed in the same directory as it is in on the development machine. If I could use a DSN or a relative path then I can easily connect to the database during development and after it's been installed on the client system. I could code it to use a variable the points to the database location and use the variable in the database location string but that make it impossible to use the handy database tools in VS.NET. Well, not impossible but extremely inconvienant. I'd have to go in and modify the code it generates everytimes it generates.

Well, does anyone have any thoughts on this.


Thanks,
Scott MacMaster