Author: Brian Pow
Posted: 2013-08-07 07:21:06 Link
My apologies for such a nursery-type question on this forum.
I have a twenty-year-old British CRM program called ProAction which I use
daily and do not want to give up as it continues to be very useful indeed.
It uses FoxPro version 1.02 (I'm pretty sure) and runs on a Windows XP SP3
desktop. (I also have a Windows 8 64-bit laptop, BTW, which is why I can't
use ProAction on the more modern OS.)
As you will have guessed, the program is no longer supported so I am asking
for your advice on how to recover database files following the XP computer's
crash.
What has happened, and what I have done about it, is as follows:
1. On loading the ProAction program, I got a "Not a database" error message.
This had also happened many years ago, and I was given verbal support and
told to use one of the files which come with the program, and it worked.
Now, having stupidly lost my notes (if I ever made any), I took a guess and
used FOXFIX.EXE which seemed the obvious one. This simply opened a command
screen which asked if I wanted to overwrite FOXFIX.001. Whether I answered
yes or no, nothing happened.
2. I bought DBF Recovery Toolbox and ran it.
It "recovered" a number of *.dbf files (but not others: they might have been
OK, I suppose). I renamed the old *.dbf files and replaced them with the new
ones.
Now, on starting the ProAction program I get a "Record is not in index"
message. If you click [continue],
"Database is not indexed. [Cancel] [Ignore] comes up.
If you choose [Ignore], the message says "Error 26 in program ON."
(new line) "Database is not indexed." (twice). "Details have been
recorded."
3. For info, the "obvious" FoxPro files which came with the program are:
FOX.FIX.001
FOXFIX.EXE
FOXFIX.FIP
FOXFIX.FXP
FOXHELP.DBF
FOXLAN.BAT
FOXPRORT.OVL
FOXPRORT.RSC
FOXSWAP.COM
>From what you can tell, does the ProAction program carry its own first aid
kit? Can I repair it "from the inside", as it were?
I should say that I have asked this question on another forum and have
received very kind and patient advice. Suggestions have included:
* Running ProAction in Hyper-V on my Windows 8 laptop (not possible because
Hyper-V only runs on W8 Pro or Enterprise).
* Buying a copy of FoxPro 1.x and (somehow) reindexing the tables (I simply
wouldn't have a clue how to do this: willing to try, but not a very
cost-effective option.)
* Taking the problem to a FoxPro user group...
What would be your suggestion, please?
* Can I use any of the files listed above to fix the problem, for example?
* In another thread in this forum, I think I detected a hint that you could
delete the index files (*.NDX ?) which would then be recreated
automatically. Is this possible?
I cannot help but feel that the answer is tantalisingly close.
And I need hardly say that any advice would be very gratefully received.
Please forgive this long post and thank you for reading this far.
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/080025BC408C4520815C22ABAF6E3044@acer2013
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Alan Bourke
Posted: 2013-08-07 07:32:39 Link
On Wed, Aug 7, 2013, at 01:21 PM, Brian Pow wrote:
> * Running ProAction in Hyper-V on my Windows 8 laptop (not possible
> because
> Hyper-V only runs on W8 Pro or Enterprise).
Nothing to stop you creating a virtual machine running XP SP3 using MS
Virtual PC or VirtualBox, and running it in that though.
> * Buying a copy of FoxPro 1.x and (somehow) reindexing the tables (I
> simply
> wouldn't have a clue how to do this: willing to try, but not a very
> cost-effective option.)
FoxPro for DOS 2.6 or FoxPro for Windows 2.6 would also work.
> And I need hardly say that any advice would be very gratefully received.
I think your best bet is to put it out to tender - see which old-time
Fox people could take a zip of the entire program folder off you and try
to get it running.
Further advice would be take backups. But you've probably realised that
already. :)
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/1375878759.8316.7075359.457705EA@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Kurt @ VR-FX
Posted: 2013-08-07 07:43:28 Link
On 8/7/2013 8:32 AM, Alan Bourke wrote:
> On Wed, Aug 7, 2013, at 01:21 PM, Brian Pow wrote:
>
>
>> * Running ProAction in Hyper-V on my Windows 8 laptop (not possible
>> because
>> Hyper-V only runs on W8 Pro or Enterprise).
> Nothing to stop you creating a virtual machine running XP SP3 using MS
> Virtual PC or VirtualBox, and running it in that though.
I'm glad you made that suggestion - since I was going to point out
something like that...
>> * Buying a copy of FoxPro 1.x and (somehow) reindexing the tables (I
>> simply
>> wouldn't have a clue how to do this: willing to try, but not a very
>> cost-effective option.)
> FoxPro for DOS 2.6 or FoxPro for Windows 2.6 would also work.
I know you can save out files from VFP to an older FPD 2.6 format. But,
yeah - wasn't sure about the Index file creation - and if you could do
the Same with that and create it in an older format.
>
>> And I need hardly say that any advice would be very gratefully received.
> I think your best bet is to put it out to tender - see which old-time
> Fox people could take a zip of the entire program folder off you and try
> to get it running.
>
> Further advice would be take backups. But you've probably realised that
> already. :)
Recently as I was going thru my belongings - as I did a Move - I came
across some really old FP disks - possibly it FP for DOS. I might be
able to lay my hands on it - and might be able to help out...
-K-
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/520240F0.2060607@optonline.net
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Jean MAURICE
Posted: 2013-08-07 08:12:42 Link
Even the Foxil works with a newer Foxpro version than 1.02 !!!!
I still have FPD2.0 on an old computer and I can try to reindex the files but I
don't think that the .dbf memorize the index key of an .idx. I mean that we
can't do a simple REINDEX command.
On a side note, did you write proAction or did you buy it. In another words have
you the source files of it ?
The foxil
--
Jean MAURICE
Grenoble - France - Europe
www.j-maurice.fr
www.atoutfox.org
www.aedtf.org
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/520247CA.1010002@wanadoo.fr
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Kurt @ VR-FX
Posted: 2013-08-07 08:23:11 Link
On 8/7/2013 9:12 AM, Jean MAURICE wrote:
> Even the Foxil works with a newer Foxpro version than 1.02 !!!!
> I still have FPD2.0 on an old computer and I can try to reindex the
> files but I don't think that the .dbf memorize the index key of an
> .idx. I mean that we can't do a simple REINDEX command.
I also thought that didn't sound right. I think this is supposed to be
the case with another format. Seems like maybe w/CDX - but, even that
doesn't sound right - since, if you wipe out the CDX - there is no way
for the DBF to know the index structures. Maybe if the DBF is within a
DBC - but, I don't have enough experience w/DBC - since they were almost
never used at my previous jobs...
> On a side note, did you write proAction or did you buy it. In another
> words have you the source files of it ?
From all of what I read of his post - he is purely a User - and it
sounds like the developer of ProAction is out of business. That's
probably because they were still running an old FP 1.0 app - and never
bothered to try and upgrade it! :-)
-K-
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/52024A3F.8010509@optonline.net
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Stephen Russell
Posted: 2013-08-07 08:30:00 Link
FP 1.0 Now that is some old stuff. The magic of browse was unleashed.
On Wed, Aug 7, 2013 at 8:23 AM, Kurt @ VR-FX <vrfx@optonline.net> wrote:
>
> On 8/7/2013 9:12 AM, Jean MAURICE wrote:
>
>> Even the Foxil works with a newer Foxpro version than 1.02 !!!!
>> I still have FPD2.0 on an old computer and I can try to reindex the files
>> but I don't think that the .dbf memorize the index key of an .idx. I mean
>> that we can't do a simple REINDEX command.
>>
>
> I also thought that didn't sound right. I think this is supposed to be the
> case with another format. Seems like maybe w/CDX - but, even that doesn't
> sound right - since, if you wipe out the CDX - there is no way for the DBF
> to know the index structures. Maybe if the DBF is within a DBC - but, I
> don't have enough experience w/DBC - since they were almost never used at
> my previous jobs...
>
>
> On a side note, did you write proAction or did you buy it. In another
>> words have you the source files of it ?
>>
>
> From all of what I read of his post - he is purely a User - and it sounds
> like the developer of ProAction is out of business. That's probably because
> they were still running an old FP 1.0 app - and never bothered to try and
> upgrade it! :-)
>
> -K-
>
>
> ______________________________**_________________
> Post Messages to: ProFox@leafe.com
> Subscription Maintenance: http://mail.leafe.com/mailman/**listinfo/profox<http://mail.leafe.com/mailman/listinfo/profox>
> OT-free version of this list: http://mail.leafe.com/mailman/**
> listinfo/profoxtech <http://mail.leafe.com/mailman/listinfo/profoxtech>
> Searchable Archive: http://leafe.com/archives/**search/profox<http://leafe.com/archives/search/profox>
> This message: http://leafe.com/archives/**byMID/profox/52024A3F.8010509@**
> optonline.net<http://leafe.com/archives/byMID/profox/52024A3F.8010509@optonline.net>
> ** All postings, unless explicitly stated otherwise, are the opinions of
> the author, and do not constitute legal or medical advice. This statement
> is added to the messages for those lawyers who are too stupid to see the
> obvious.
>
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMYKC3JanYfA=JONd3-z9JYs+r3=V=rbzhLgTW77RVCYCYg@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Paul Hill
Posted: 2013-08-07 08:57:29 Link
On 7 August 2013 14:30, Stephen Russell <srussell705@gmail.com> wrote:
> FP 1.0 Now that is some old stuff. The magic of browse was unleashed.
Wouldn't this have been called FoxBASE?
--
Paul
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CADwx0+K6OJaLTNW2Fz8pzzkBO8+RE8Ly2W8vD+shGU4mKUXeUw@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Stephen Russell
Posted: 2013-08-07 09:01:28 Link
was it
browse in window myUglyWindow?
Maybe that was it. Windows, in dos of course.
On Wed, Aug 7, 2013 at 8:57 AM, Paul Hill <paulroberthill@gmail.com> wrote:
> On 7 August 2013 14:30, Stephen Russell <srussell705@gmail.com> wrote:
> > FP 1.0 Now that is some old stuff. The magic of browse was unleashed.
>
> Wouldn't this have been called FoxBASE?
>
> --
> Paul
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMYJjbvP3hCU3igYDRz0Eu=80_Fu=eUF21Qim_NyB2QKtYg@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Dave Crozier
Posted: 2013-08-07 09:03:53 Link
Foxbase for DOS it certainly was... I have V1 and also the little distributed Multi User Foxbase for DOS and also the black Manua with the original fox on the front!
Dave
-----Original Message-----
From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Paul Hill
Sent: 07 August 2013 14:57
To: ProFox Email List
Subject: Re: FoxPro v1.02 database problem following computer crash
On 7 August 2013 14:30, Stephen Russell <srussell705@gmail.com> wrote:
> FP 1.0 Now that is some old stuff. The magic of browse was unleashed.
Wouldn't this have been called FoxBASE?
--
Paul
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/18725B8CD2D5D247873A2BAF401D4AB223B5FA6D@EX2010-A-FPL.FPL.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: John Weller
Posted: 2013-08-07 09:22:42 Link
FoxBase was renamed Foxpro 1.0 after Ashton-Tate objected to the name I
believe.
John Weller
01380 723235
07976 393631
>
> Wouldn't this have been called FoxBASE?
>
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/004101ce9379$94c61b20$be525160$@johnweller.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.