I have a MSAccess 2010 front-end application pointing to tables in SQL 2008 SP1. Security is integrated windows, so if they're logged into a computer, they get access. We try to keep things simple. Currently we're having to set up a file DSN on each users computer to make the linked tables work, and constantly have to relink the tables due to users messing with the DSN definition, etc..
The obvious solution is to hard-code DSN-less connections at application start up, as the table definitions will never change.
There are A TON of examples out there on how to do this, but my problem is that all these great examples seem geared towards folks that are expert VB programmers, and a bit over the learning curve of a typical access user without a computer programming degree. Are there any SIMPLE tutorials or examples that clearly explain this concept? Perhaps an Access Database that one can download that has all the example code embedded in these module-thingies? Forgive my ignorance, I know as much about access databases as I do nuclear physics, is just the hat I've been assigned to wear. Thanks.