Hi, Sylvia,

I would very much like to have these SQL scripts for turning on/off the Public Access in the Objects, Media, and Constituent modules.

Thank you for the offer! You and send them to me at
[log in to unmask]

Christine
From: The Museum System (TMS) Users <[log in to unmask]> on behalf of Welsh, Sylvia C. <[log in to unmask]>
Sent: Thursday, December 7, 2017 8:09:35 AM
To: [log in to unmask]
Subject: Re: Tweaking a quey
 
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.
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.