Good catch Christina! Try this: update packages set packages.locked = 1 where packages.packageid in (X,Y,Z) and packages.tableid = 108 X,Y,Z being the different packageids for the packages you want to lock. - Rob -----Original Message----- From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Christina Gibbs Sent: Friday, April 5, 2019 5:01 PM To: ListServ tmsusers <[log in to unmask]> Subject: Re: batch lock object packages? And throw tableID = 108 (objects). Unlikely, but if you are using packages in other modules, it is possible to have a package in more than one mod w/the same ID. Christina Christina Gibbs Collections Database Manager Detroit Institute of Arts 5200 Woodward Avenue│Detroit, MI -----Original Message----- From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Morgan, Rob Sent: Tuesday, April 02, 2019 4:55 PM To: [log in to unmask] Subject: Re: batch lock object packages? Hi Liz, You can batch lock object packages via the backend, via SQL. I'd recommend trying on a test, first, before you apply to production. update objectpackages set objectpackages.locked = 1 where objectpackages.objectpackageid in (X,Y,Z) X,Y,Z being the different objectpackageids for the packages you want to lock. Good Luck! - Rob Morgan IT Specialist in Data Management and Systems Administration Office of the Chief Information Officer Smithsonian Institution -----Original Message----- From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Liz Byrne Sent: Tuesday, April 2, 2019 4:29 PM To: ListServ tmsusers <[log in to unmask]> Subject: batch lock object packages? Hello - Is it possible to batch lock a bunch of object packages, rather than doing it one by one? Thanks! 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.