Subject Re: inno indexing problem? more info From Charlie <tm@tc.com> Date Sat, 03 Aug 2024 13:25:55 -0400 Newsgroups dbase.getting-started More info.   I believe this is an mdx problem.  When I click on a link that is supposed to go to the indexed row instead it goes to the top row. I do have a bde in inno and it works fine in my previous project which i changed to this.  I am almost certain that the indexes are not working in at least one table.  This makes no sense to me but might be a problem in windows or could I have too many indexes in this table? Charlie Wrote: > 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?