Alrighty then..., First off you have a major problem you are using DSN's and not deploying them. You should not even be using DSN's with an Access Database. OLEDB would work better and have no extra overhead to deal with on the installation and it would be far simpler too.

Working on the rest...