Wednesday, June 09, 2004

FileMaker - Opening Many DBs

My FM client has password protection on his DBs, and I’ve spent a LOT of time typing this password over and over (and over and over) again for each DB that I need to access. Yesterday, I finally got sick enough of it to do something about it. The following steps assume that you have the same password for all DBs, but it may be possible with different passwords, too.
- Create a new password protected DB, with the password being the same that you need in the other DBs.
- In this new DB, create a script which opens the DBs that you need
- Open “Edit / Preferences / Document” and check the “Try Default Passord” checkbox, but do NOT enter the password.
- In this dialog, you also want to check the “Perform Script” checkbox, and indicate the script that you created to open the DBs.

Voilá - you only have to enter the password once to open all the DBs.