Hi Adrian, I have some SQL scripts saved which either turn-on Public Access for all Objects/Sites/Media (depending on your needs) and one that turns-off all Public Access. I am happy to share them with you if they might be of use - please let me know and I will send them via email. Sincerely, Sylvia, _____________________________ Sylvia Welsh, MS LIS, CSI, LEED AP BD+C Harvard Property Information Resource Center 1350 Massachusetts Avenue, 547 Cambridge, MA 02138 T 617-496-8275 F 617-495-0559 -----Original Message----- From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Parsell, David Sent: Thursday, December 07, 2017 7:39 AM To: [log in to unmask] Subject: Re: Tweaking a quey The mediaXrefs table provides the link between Objects and MediaMaster tables. Objects.objectID=mediaXrefs.ID mediaXrefs.mediamasterID=mediamaster.mediamasterID I suggest asking GS technical support these technical questions. Brian and Dimytri respond quickly and are very technically adept. David Parsell Yale Center for British Art -----Original Message----- From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Adrián Pérez Camarena Sent: Wednesday, December 6, 2017 4:42 PM To: [log in to unmask] Subject: Tweaking a quey Hi dear friends, I would like to know how can I update the check "Public Access" from the Objects module and from the Media tab in the same module executing a query from the data base and which tables are involved in this query and what is the field that makes the link between Objects table and MediaMaster table. I can not find a field that makes the link between this two tables, I think there must be a third table. I have to update about 1000 records and I would like to do it with a query. Has anyone else come across this a managed to resolve it? Thank you. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.