Greg M Posted March 24, 2004 Share Posted March 24, 2004 This is a neat little VBScript that pulls the user's logon username, as well as computer number, and saves it to a text file on the hard drive. (Note: Windows only) The script can be executed through a Send Message step when opening the database, and the data can be imported to not only assist in custom file permissions (field-level, if you so desire) but also to create logs of who accessed your database system. So you don't even need a password-based login system, this script is basically flawless. I'd be happy to provide an example database if needed. Note: When using calling this script from Filemaker, and importing data from the text file, it takes a few seconds after executing the VBScript for the text file to become available for Filemaker to import. To make sure this goes error free, use a script step like the one that follows: Allow User Abort [Off] Loop Import Records ["username.gm"] Exit Loop If [status(CurrentError)=0] EndLoop Allow User Abort [On] If that file can't be found, it will return an error, which will cause the script to loop again. The loop will only be exited once the necessary data has been successfully imported. Version: v6.x Platform: Windows 2000 UsernameScript.zip Link to comment Share on other sites More sharing options...
2 letter pi Posted April 22, 2004 Share Posted April 22, 2004 Can you send a sample database to show me how you use the script to "read" passwords to set privileges on opening the database??? FileMaker Version: 6 Platform: Windows 2000 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7282 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now