I wondering is there any way to programmicly setup a DSN(OBDC) to a MS Access database. Basicly I want the users to be able to push a button and setup a DSN for there local MS Access database. Any ideas?
The short answer is "yes", but it depends upon how you prefer to go about it. If you like doing things the old-fashioned way, you should be able to do it using batch files. This is a pretty good way if all the users are configured the same. If you need to do it for any of several different Windows OSs, you might want to consider something like InstallShield Express (I'm not trying to push their software(it's not exactly cheap...around $600 with support, last time I checked), but could save you a lot of time and effort. ...and you can try it for free. I haven't checked out the stuff from WISE, but they probably have something comprable.
I'm sure that others may have some additional solutions as well.