and not reveal the required privilege set's info in the remote "Cash Register" DB file?
exactly what do you mean by that?
I can't quite picture what "info" that would be...
If I want to Login in, I must enter Admin's user name and password. To automatically start up a DB using Admin security, the name and password to access that External file, must be entered by a script. I think??
Is there a way, using a start up script, to supply the USER / Password and keep it concealed in the "Cash Register" DB?
Still scratching my head on what you want...
Any FileMaker file will open another password protected FileMaker file automatically and without asking for a password IF there are matching account names with identical passwords set up in both files. And these accounts can be "synched" between files using scripts, global fields and passwords.
So I'm not sure I picture why a script would have to specify the account name and password to open a file nor why it would have to be the Admin account to do so.
Maybe this is the reason, You want a script to modify data in the other file to run with "full access permissions". You can do that by using perform script in file 1 to perform a script in file 2. The script in file 2 can then be set to run with full access permissions and to modify the data that a "run with full access permissions" script in file 1 cannot modify.
HOSTing a DB which has an Admin only restriction.... Call it File 1 It contains Personel Info, not restricted, like Name and Phone.
New DB file designed for Salespersons who have NO access to the main Accounting File, but with an External Ref to File 1.
So per FMP help...
I opened the main Accounting Files, with the proper sequence, and File 1 is opened.
The new DB File 2, not part of the Main Account Files, is now Opened in the HOST. New set of Security, except for Admin.
The start up script of File 2, needs non restricted Data from File 1. No problem except, to access File 1, since it is an External File, does not recogize the standard "Run script with full access privileges".
I get the USER/Password log in screen for trying to access File1 from File 2. No one around to type it in at 3am or power down resart of HOST.
I didn't want to leave the Admin Name/Password in a script in File 2.
I suppose i need to set up a Script in File 2 with restricted security to Start up File 2 and access File 1, Then use Re-Login to force the Clients to have a name/password to access the HOSTed File 2.
I wouldn't set up the file to have only an admin account. I'd give it a limited access account that works with the second file to permit access at just the level needed. You could even set up the first file to automatically open with the limited access account/password.
Then users that need admin access can click a relog-in button, open with the shift/option key or can open from a different "opener" file to which only they have access that is opened with the same account/password as the admin account in file 1...
This avoides an overt reference to a password and account name as literal text in a script--something that's both a security risk and a pain to update if you ever need to change the account name and password in file 1.
From help....Note To set up recurring imports, you must open a file with an that is assigned the Full Access privilege set. For information about privilege sets, see About accounts, privilege sets, and extended privileges. Users do not need to use an account with Full Access privileges to use recurring import after it has been set up in a file.But...You must start up File 2 using File 1 privileges from File 1. I was trying not to do that. I hoped there was another way. I do have 3 people with full access. The issue was "Starting Up" from a host and leaving File 2 as "ready to log in" with its own privileges was the issue. So i am abandoning Snapshot Link.... and doing a directed import at start up, then as you suggested, restart using a Script called from File 1. That works.Thanks...Jim...