Import Scripts and passwords
Right now I am using a script to import via an ODBC datasource from seven different databases. It works fine except for every six months when I have to change my password. Then I have to go into the scripts and find the seven "import records" lines and go through the ODBC stuff until it gets to where my user name and password is stored and change my password. Can anyone suggest something more elegant? For example, is there a way to get filemaker to prompt me once for a user name and password, and then use that pair for each of the seven imports? I originally wrote this for myself, but have recently have modified it for collegues to use, so I want it wo be as seemless as possible.