Subject inno indexing problem? From Charlie <tm@tc.com> Date Sat, 03 Aug 2024 11:21:41 -0400 Newsgroups dbase.getting-started I don't know if anyone can help with this but I hope so. I have a project that works fine in dbase or a shortcut on the same computer.  I originally had the original inno file to setup in the user file and it worked well with the data in the folder below it.  But I didn't like that the user had to use that directory at setup and there are security issues so I re-wrote some of the code to allow data to be put in the programData file.  The revision also works well in dbase or shortcut. But there is some sort of an indexing problem if say you install the program in the programFile (x86).  When I install it there i think it is windows will not handle the mdx files or something similar.   When the program opens the collection.dbf appears to be ok, but if you browse down the last record seems to be repeated infanite times.  So if I try to change the index everything disappears and then the program fails.   If you try to run it again I get a weird database engine error...  access to table disabled because of previous error.  And then the form won't close unless you go into task master and close it.  I have several indexes on this table.   But like I said before I changed the inno to allow for the programdata, it worked fine. I was thinking possibly the fact that the .DBF was upper case and .mdx was lower that was the problem but no deal. Sorry this is so long but it really seems complicated.  Hopefully the solution is simple! Can anyone offer any suggestions?