Script to enter password upon opening file?

[AlanM]

I'm doing a summer intern designing databases for a engineering firm.

My employer would like to be able to run a startup file that automatically opens (with passwords) the shared files for the company intranet. Is there any way to have passwords automatically entered using scripts or plug-ins (or anything else)?

Any help would be greatly appreciated (ASAP)!

[ryan93]

Just off the top of my head it should be possible. Make a script that opens the files you need open. When it gets to steps where you have to enter passwords use the "insert text" script command under the "Fields" category. Then just type in what the password is under "specify." Hope this works.

P.S. I'm an intern as well. I'm interning for accounting and developing an inventory database that tracks purchases and material requisitions. I know Access but they want it on FMP 5. So I know what you're going through. Good luck!

------------------

Ryan

[email protected]

[AlanM]

Thank you very much Ryan93 for your quick response. I have tried your solution, but the "insert text script" requires a specific field, and the "password" prompt isn't a field that I can find (it is defined in access priviledges). This is a very perplexing problem... Any more ideas anyone?

--AlanM (original poster)

[AlanM]

quote:

---

Originally posted by geod:

Try this. Open Preferences. Click Document Preferences. You will see the heading, "When Opening xxxx.fp5(fp3)

Try Default Password.

Click the checkbox and type in your password.

OK

---

geod,

Thank you for your suggestion, this will definitely open the file with the entered default password, but...

The problem comes when sharing--each user has the same Document Preferences as set by the host! If my employer opens sensitive data with the master password (a requirement to host complete access), then anyone who logs on as a guest will automatically be entered with the same master password and thus have complete access to all records.

The puzzle continues, any more suggestions (ANYONE)?

[Kurt Knippel]

quote:

---

Originally posted by AlanM:

Originally posted by geod:

Try this. Open Preferences. Click Document Preferences. You will see the heading, "When Opening xxxx.fp5(fp3)

Try Default Password.

Click the checkbox and type in your password.

OK

---

geod,

Thank you for your suggestion, this will definitely open the file with the entered default password, but...

The problem comes when sharing--each user has the same Document Preferences as set by the host! If my employer opens sensitive data with the master password (a requirement to host complete access), then anyone who logs on as a guest will automatically be entered with the same master password and thus have complete access to all records.

The puzzle continues, any more suggestions (ANYONE)?

The answer is to do the following. Setup a script in the main (or starter) file which opens all the other files.

Then uncheck the "Try default password" option in preferences on the starter file.

Now the user will be prompted for a password on opening the file and FMP will feed that same password to all the other files that FMP opens.

For added security you could set all the other files to open with the user password by default, just in case a user opens the wrong file.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.inthescene.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

[geod]

Try this. Open Preferences. Click Document Preferences. You will see the heading, "When Opening xxxx.fp5(fp3)

Try Default Password.

Click the checkbox and type in your password.

OK

[danjacoby]

One more thing...

If you have a blank password with highly limited access, you can set this as the default password. Then, when you're opening the first file, hold down the option key (for Macs), or the shift key (for Windows) to bring up the password entry box.

Dan

[ppo]

Hi,

If all the files concerned have the same password definitions, you just have to write a script from the first DB which opens the others DB.

FmP, before opening the files, will check that the passwords are the same and will open the files with the rights attached.

Hope this helps. Thanks for keeping me informed.

Pat

[AlanM]

THANK YOU ALL VERY MUCH for your help, it looks like the only way to do this is to have the same master password for all of the files to be opened.

I discussed this with my employer and he is determining whether or not to implement such a password change. Unless there is an unknown way to enter different passwords with a script, then this discussion is closed. Thanks again!

--AlanM (original poster)