| Subject | Re: inno indexing problem? |
| From | Ken Mayer <dbase@nospam.goldenstag.net> |
| Date | Sun, 4 Aug 2024 05:31:43 -0700 |
| Newsgroups | dbase.getting-started |
On 8/3/2024 8:21 AM, 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? The table files should be in programdata. the other folder (programfilesx86) is read-only for your users, and it should be. This is in intentional on the part of Windows. Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm dBASE DOS to Windows Tutorial: http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm | |