Archive for the ‘Technology’ Category

Posted on April 24, 2008 - by Alex

View tables and queries in Microsoft Access with locked switchboard!

Just wanted to drop in and share this: If you open a Microsoft Access file (2000-2007 I believe), and you are presented with the application “switchboard” and cannot access the tables, queries, reports, etc., you can exit Access, and then hold the shift key and double-click the file, and it will open into the administrative pane! Nice! Also, apparently if a database was created in Windows 2000 or on a secured XP/Vista network, and you move it to another computer and start having errors, check the detailed NTFS file sharing settings, because apparently you are allowed to open and seemingly manipulate the database if it was previously secured, but none of your changes will persist.