I recently upgraded from Access 2003 to 2010. I like the new version, except I can't figure out how to store ODBC / MySQL linked DB passwords locally. My users are asked to reenter the password every time they open the application.
The 2003 Linked Table Manager had a "Save Password" check box, but it is missing from the 2010 version.
Thanks in advance for the help.