Hi

I've added the following script to some databases I administer inhouse that request a password after a specific date has passed. This script is set as the startup script (using "Perform AppleScript" in Scriptmaker) - each month I'll change the expiration date so users should never see it.

Bearing in mind that I'm the only one with the admin password, access to document prefs and scriptmaker is there anyway users can bypass this if they don't have the admin password.

If anyone has a better way of writing the script I'd be interested in that as well

Ta!!

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

property expiration date "January 11, 2005"

property mypassword : "passwordtext"

on run

try

set currentDate to (current date)

tell application "Finder"

if expiration > currentDate then

tell application "FileMaker Pro"

activate

end tell

else

set the_password to text returned of (display dialog "Enter the password" buttons {"OK"} default answer "" default button {"OK"})

if the_password is equal to mypassword then

tell application "FileMaker Pro"

activate

end tell

else

tell application "FileMaker Pro"

quit

end tell

display dialog "Sorry, that is incorrect - FileMaker is quitting now" buttons {"OK"} default button "OK"

end if

end if

end tell

end try

end run

I'm assuming that you'd designate it under File > File Options... > Open/Close tab > Perform Script