Handy Library Manager
 for Windows


Help, how to topics > Library Users > How to delete borrower?


How to delete borrower from the system?

You cannot delete or move a borrower record if the borrower has outstanding (not returned) items. Process check in transactions.

If you move or delete borrower record all borrower's loan transactions will be deleted.


remove delete patron, decide about loans

Decide what you want to do with old loan transactions. When borrower is removed from BORROWERS table all borrower's loan transactions will be deleted.

You can move selected loan transactions to OLD_LOANS.


move selected loan transaction to old loans table

How to move loan transactions to OLD_LOANS?

  • Open LOANS table.
  • Define search, use borrower's barcode number or name to display selected loan transactions.
  • On the Move Loans tab click Move All Loans or Move Loan.

delete permanently or move to old borrowers table

How to delete or move borrowers?

  • Open BORROWERS table.
  • Click Delete to delete the record, or select Move Borrower and click Execute to move the record to OLD BORROWERS table.

remove, delete confirm message
  • Review the message. Click OK to continue.

old borrowers table

Open BORROWERS_OLD table.

Moved records are listed in BORROWERS_OLD table.

You can move back all or selected borrowers to BORROWERS table. Old borrower's check in-out transactions will not be reactivated in LOAN table.



Question: How do I delete borrowers? The Eighth grade graduated in June 2017 and I want to remove their names as well as some other children who have transferred to other schools. I will do this later in the school year.

Answer: Define advanced search to display only Eighth grade students. Click Miscellaneous, and click Delete All Borrowers. The system will delete only displayed borrowers. Before executing Delete All create a backup of your library databases.


Question: I deleted an item but didn't realize it was still checked out to a patron. I would like to return the item so that it doesn't appear the patron still has possession. If the item can't be reinstated, is there a way to delete the patron along with the item?

Answer: Please update to the newest version of our Handy Library Manager. The error is corrected; the library system does not allow to delete items or borrowers from databases if there are unfinished transactions (items are not returned or borrowers still have some things checked in).


Question: Hi I am trying to delete all of the loaded student names without having to delete one at a time and upload an updated file, how can I do this?

Answer: Open the Borrowers window. On the Miscellaneous tab, use the delete command.


Copyright © 2024 · All Rights Reserved · PrimaSoft PC