You should be using integrated security. But since we don't control all the things, sometimes database password authentication is forced on us. You can set up a file DSN with the password, but in MS Access it is never saved. Instead everytime you reopen the database and view a table you see this: Here is the workaround. Create a special type of query called a Pass-Through Query which does store passwords Create a macro that runs this query at startup This works by initiating a special silent query at startup using the password. Once the database password has been used once, it is cached for the MS Access session. Create the Pass-Through Query On the Ribbon choose the Create Tab and click Query Design Close the Show Table dialog Click the Pass-Through button on the Design Tab Click Property Sheet to edit the connection string properties. You can paste a connection string or use the ... builder to open a GUI. If you use the builder be sure to choose to Save the pa
In a recent design we needed a giant button that would scale well from mobile to desktop. By combining viewport width scaling and pixel scaling with a calculation you can make a font size scale, but never scale smaller than a minimum size. <a href="#example" style="display: block; background-color: #5588aa; padding: 20px; color: #fff; text-align: center; font-size: 30px; font-size:calc(30px + 1.6vw);">Big Button Text</a> Demo: Big Button Text Both calc and viewport-units have wide support right now. Remember to set a fallback font-size for fringe browsers. More information Chris Coyier: Viewport sized typography David Walsh: A Couple of Use Cases for Calc() Jen Simmons: Progressing Our Layouts Vasilis van Gemert: Create the perfect website layout system