I am trying to allow a user who is remotely connected to the database, to execute a script that clones the database and saves to a networked (shared) folder.

 

However, when the remote user clicks the button, nothing happens. The script is only one step for now as I am just testing a solution. It is the "Save a Copy As" script step, which contains the correct filepath to the shared drive.

 

I am able to execute the script from my computer which hosts the actual database file with no issues.

 

 

Any ideas? Thanks.

That's not possible.  If it were, it would be a huge security issue allowing folks to "download" a copy of the data and the intellectual property in the business logic.

In other words - hosted files cannot be Saved As...

Thanks for the reply's guys, makes sense from a security standpoint.

 

I understand the security issues, but I was just wondering why it wasn't working since the scripts seemed to be written correctly. I thought perhaps there was another issue.