MS Access Annoyance: Yes, Save the Password, Again

Here’s another quirk that has been there forever. Open up the linked table UI and select a handful of tables, like so:

image

Note the save password box is checked. Click ok, and then you get this fun dialog after you enter your password, once for each table/view you selected. Seriously, we couldn’t get an intern to add a checkbox ‘apply to all’ or something like that rather than hammering on the mouse until this dialog goes away?

image