Subject Re: inno indexing problem? From Charlie <tm@tc.com> Date Sun, 04 Aug 2024 15:37:56 -0400 Newsgroups dbase.getting-started Hi Ken..  Yes that is exactly what I am doing.  Program files are in (86) and database is in programdata now.   I did find that even so the database folder was read only.  I think I fixed that and they are not read only.  (I added ; Permissions: users-modify)  and now the tables don't look like they are read only at least in dbase.   But they are acting like they are using the setup program.  So I am still having problems.  Still working on it though.  Hopefully there will be an end to this insanity!! Ken Mayer Wrote: > 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 >