AnsweredAssumed Answered

[Full Access] Script doesn't work with External Data Sources... any work-around?

Question asked by rensys99 on Jul 21, 2012
Latest reply on Jul 21, 2012 by philmodjunk

Summary

[Full Access] Script doesn't work with External Data Sources... any work-around?

Product

FileMaker Pro

Version

FMP Advanced v10.0

Operating system version

Windows XP, IWP and FMP under Filemaker Advanced Server v10.0

Description of the issue

[Full Access] Script does'nt work under these conditions....

- Using a data separation model with Scripts in main file, and data in External Data Source with .fp7 file

- Privilege Set in External Data Source for certain data elements set-to 'view only' for certain Accounts and certain data elements with 'Limited' access

- Same Privilege Sets being used in the main file

Now... we have a script (in main file) set to 'Run script with full access privilege' -- but when logged in as an Account with limited Privilege Set, the script will not execute 'Set Field' for the target field in the external data source which was set-to 'view only' for the log-in Account with limited Privilege Set.  

This script should execute as if it were being run under [Full Access].

Are we doing something wrong? Or is there a work-around for this apparent issue?

Outcomes