I have a problem deleting index file.

I use command INDEX ON someExpr TO temp.idx on one table in one work area.

I open same table in another work area and when I want to delete temp.idx it says that file is in use and I cannot delete that index.

How to delete that index file because BEGIN TRANSACTION command is requiring that?