I have developed several Excel workbooks for a client to track some sales
data from an Access database. One issue they have had is people inputting
data that shouldn't be and others unprotect sheets and change formulas. I
would like to assign read only, read/write and admin permissions to both the
Access database and the Excel workbooks. I think their network
administrator can do this, but my question is, if they make those changes,
can I still work on the files off site? Do the permissions disappear once
it leaves the group policy/permissions settings in the network/domain. Or,
do they need to add me as a user, although I am not in their network? Not
sure how to set this up so we can both manage the files.

Thanks!