@Awiener the hint of @NurSenaAlici to COMPACT the database is the right approach. Also make sure you do not hit any restrictions that MS Access might have.
further down in this thread there are options to handle larger local databases if you do not have to use MS Access.
Another option would be Duck DB