Okay so I tested and I have a better understanding of what's going on now.
There are 2 files the .GDT and .GIX file when using classic database. When you go to "Index" and CLEAR the database, it deletes the .GIX file but NOT the .GDT file. When the user tries to re-index the database, it will give you the error "The database is being changed by someone and cannot be opened for reading (10010)." because the .GDT file is still there. I have to manually delete this file to be able to re-index it.
Now the question is was that .GDT file being deleted in previous versions prior to updating to 2022.3? Also is it better to clear the database first and then Index for a cleaner slate or just to re-Index the current database?
