Index
2013-08-07 07:21 – Brian Pow : FoxPro v1.02 database problem following computer crash
2013-08-07 07:32 – Alan Bourke : Re: FoxPro v1.02 database problem following computer crash
2013-08-07 07:43 – Kurt @ VR-FX : Re: FoxPro v1.02 database problem following computer crash
2013-08-07 08:12 – Jean MAURICE : Re: FoxPro v1.02 database problem following computer crash
2013-08-07 08:23 – Kurt @ VR-FX : Re: FoxPro v1.02 database problem following computer crash
2013-08-07 08:30 – Stephen Russell : Re: FoxPro v1.02 database problem following computer crash
2013-08-07 08:57 – Paul Hill : Re: FoxPro v1.02 database problem following computer crash
2013-08-07 09:01 – Stephen Russell : Re: FoxPro v1.02 database problem following computer crash
2013-08-07 09:03 – Dave Crozier : RE: FoxPro v1.02 database problem following computer crash
2013-08-07 09:22 – John Weller : RE: FoxPro v1.02 database problem following computer crash
Back to top
FoxPro v1.02 database problem following computer crash

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.

©2013 Brian Pow
Back to top
Re: FoxPro v1.02 database problem following computer crash

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.

©2013 Alan Bourke
Back to top
Re: FoxPro v1.02 database problem following computer crash

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.

©2013 Kurt @ VR-FX
Back to top
Re: FoxPro v1.02 database problem following computer crash

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.

©2013 Jean MAURICE
Back to top
Re: FoxPro v1.02 database problem following computer crash

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.

©2013 Kurt @ VR-FX
Back to top
Re: FoxPro v1.02 database problem following computer crash

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.

©2013 Stephen Russell
Back to top
Re: FoxPro v1.02 database problem following computer crash

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.

©2013 Paul Hill
Back to top
Re: FoxPro v1.02 database problem following computer crash

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.

©2013 Stephen Russell
Back to top
RE: FoxPro v1.02 database problem following computer crash

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.

©2013 Dave Crozier
Back to top
RE: FoxPro v1.02 database problem following computer crash

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.

©2013 John Weller