Cannot open index file
Posted: Tue Dec 07, 2004 6:22 pm
Xbase 8.1.023____Here^s the situation:__I have a report with both the Master table and 1 related table that I create each month. At then end of the month I point both tables to the new monthly tables. I have been doing this for several years. However, this time I first got a warning message when clicking ok after changing to the related table from the Oct to the Nov table that a calculated field will be deleted - this usually means there is a change of field attribute (i.e. first table the field is a character, 2nd table it^s an integer). So I checked both the Oct table and the Nov table and both had the calculated fields as integer.__But now when I try to open up the report I get this message:__Cannot open index file (file may be in use). (it^s not in use)__I believe the problem is with the related table after testing a bit. Also I created a report with the same master and related table and it works fine - I can open it, I can switch to different months and back again with no problems but I still can^t open up the original report. I would hate to have to rewrite it, it^s a bit complicated. __I have re-created the related table, I^ve re-indexed it.__What other steps can I take to fix this?