form quit working

[darrontrask]

Thank you for looking at this thread. I have a real problem on my hands. One of the reports that I use on a daily basis I think has become corrupt. When I try to start it I get this error message "Error loading file-record number 6. frmSpecAvg <or one of its members>. Loading form or the data environment : Not a table" this is an old patched together version of foxpro and there is no support whatsoever in this area that can help my with this. If anybody has any ideas on what I can look at I would be grateful.

Thank you all in advance.

Darron Trask

 

[Stella740pl]

What do you mean by "an old patched together version of foxpro"? What version was it written in and what version do you currently have to work with?

The form is stored in a table, with a different extension.
Try to narrow down, which table you should repare (of course, back up everything first).
First, open one by one all the tables that you have in your data environment, if any. See if it is one of them is corrupted.
Then try to open your report as a table (USE ...), just specify the extension. If it opens OK, try to use COPY TO NewName.frx WITH PRODUCTION. See if you can run that new report. If so, just rename it to your report's name.

If you still cannot run it (or even cannot open as a table), search this forum, "Microsoft: VFP - Databases, SQL&VFP, and Reports" forum and, possibly, "Microsoft: FoxPro (old versions 1 to 2.6)" forum for repair of corrupt tables. You will find some advice and links to third party products and downloads.

 

[darrontrask]

we are currently using Visual FoxPro5 Upgrade. This system has been around for about 12 years and I am not sure which version it was writtien in. I have been told that there have been numerous upgrades and Bandaids installed. I am not very familiar with FP and the lady that built this system is now gone.

 

[TamarGranor]

Based on the error message you're seeing, my bet would be that one of your data tables is corrupt. Open the form in question as a table (USE YourForm.SCX) and look at record 6. I'll bet it references a DBF. That's what's corrupt.

Tamar

 

[Stella740pl]

12 years? Probably, it was originally written in FoxPro 2.x, then upgraded somewhat.

Still, it should be no problem to try what I described above.

 

[darrontrask]

I cannot open this file what ever I try. If I run the form from FoxPro I get the error above. If I go to the File on the HDD I get this file is not a table no matter what I do. I admit I am not very familiar with FoxPro (besides the data entry) and we have no support for this DB in Western NY. I have tried opening all the tables and they open fine with the exception of this form. I am at a loss and pulling out what little hair I have left. Thank you for your input but I can't get those suggestions to work.

 

[Stella740pl]

So it's the form itself that is corrupted.

My suggestions included the following:

If you still cannot run it (or even cannot open as a table), search this forum, "Microsoft: VFP - Databases, SQL&VFP, and Reports" forum and, possibly, "Microsoft: FoxPro (old versions 1 to 2.6)" forum for repair of corrupt tables. You will find some advice and links to third party products and downloads.

If you search these three forums, you will find links to other sites with tools for table repare. People say, they are good. You might try as well.

 

[darrontrask]

I would like to add that I understand how relationships, reports, form, etc. in Access but I cannot find how these form access the DBs that we have on the HDD. If I could figure that out that might be a great help. when i go to the project manager there are no DB's listed under the data tab. I am at a loss like i said and this is only making my work back up further and further. I hope this isnt against the Forum rules But if Anyone is near the WNY area and could help me out directly I would appreciate it

 

[njpilot172]

Darron,

Many FoxPro programmers do not include the DBF files within their projects. This is especially true for "Free" tables that are not contained within a Database Container (.DBC).

Forms usually open data tables in one of two places: The "Data Environment" (available from the View menupad), or the Load() event of the form. I suggest you look at one of these two places first.

As for your form/tables being corrupt, I have found FoxFix by XITech to be extrememly useful. It can also rescue objects from corrupt class libraries (.VCX) files if you're willing to do a little extra work.

Hope this helps.

Todd

 

[DSummZZZ]

but I cannot find how these form access the DBs that we have on the HDD

They'll either be opened with a "USE" command somewhere in your form, in a startup .PRG, or in the data environment of the form. (Right->Click on your form and select 'Data Environment').
Then look at the properties of your controls and see what ControlSource they are set to.

Also, familiarize yourself with what all the different files and file types are, by hitting the F1 key, and looking for "File Extensions and File Types".
Scan through the folder containing your app, and you'll see what it consists of.

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm