I am getting the Database System Error -127 again and I can't figure out what's going on. I deleted the xstats.temp file which always fixed this in the past. But what's happening is when I click OK in the error dialog box (several times) it starts sending stats to a different folder with another part name than the one in the program. Then the error message pops up again and starts sending stats to yet another folder. The stats path in the program is correct, it worked in the past and it hasn't changed. Any ideas would be greatly appreciated.
Yes, it's in Datapage folder and no, it is not recreated. I renamed xstats11 to xstats12. xtats11 does not get recreated and xstats12 is still there with 0 bytes.
IF he is still using V.35 & V3.7 as his info states, then he is still using "old" datapage (3.32 or some such).
If that is the case, then XSTATS11.TMP is located in the INSTALL directory of Pcdmis, NOT Datapage.
Also, check for more STATS/ON commands in the program.
If there is "BAD" data in the XSTATS11.TMP file, it will never get removed, UNLESS you remove it yourself. Either by correcting the path in the file or simply by deleting the file.
Use your computer's search function and search for it, then delete ALL instances of it that are found.
Using Pcdmis 2011 mr1 and Datapage 3.33. Sorry I forgot I need to update my info. That was from a previous life. I may just do a fresh install. I'm out of ideas.
If you're using PCDMIS 2011 on Win7, the XSTATS11.TMP is located in
C:\ProgramData\WAI\PC-DMIS\2011 MR1 - note that C:\ProgramData is normally hidden by Windows.
If you're using Win XP, the folder is
C:\Documents and Settings\All Users\Application Data\WAI\PC-DMIS\2011 MR1
(This info is available in the Help, under "Understanding File Locations")
Thanks everyone for the help. Much appreciated. It's working now. I created a database on the network instead of the hard drive and it works. Thanks again.
Similar thing happened to me and I found out that a Datapage file path was corrupted in a totally different program that was ran around the same time. Note the numerous file names when datapage updates and track down your problem program that way.