database has become corrupted 1

[lvadmin]

I keep getting this error about once a week.


Table 'c:\documents and settings\administrator\desktop\usertable.dbf' has become corrupted. The table will need to be repaired before using again.

I am having problems getting rid of this error. Not even sure what is causing this error. I am running a program that ftp's to other servers looking for data. If it finds certian data it shoots it over and imports it into the main database.

Could this error be related to me constantly opening and closing my database?

Please provide me with any links or information you can and if you had this problem before, how did you get rid of it....?

Thanks,

ROss

 

[DSummZZZ]

Ususally, table corruption happens when an app (or the computer itself) is improperly shut down, thereby disallowing the table buffers to be flushed before it is closed. But bad hardware or net settings can sometimes be a big issue too.
Constantly opening and closing the table shouldn't be an issue, but that is something you should really consider recoding in order to keep the table open as long as the job is running.
How is the data being imported? As a text file? CSV? Table?
You may want to consider getting all the upadtes appended into a work table, then upon completion add the work table to the main table. That may cut down on how much the main table gets accessed too.


By the way, without trying threadjack, does the 'lv' in your handle mean you're in Las Vegas?
Just curious. That's the area I'm in.


-Dave Summers-

Even more Fox stuff at:

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

 

[lvadmin]

Appreciation for the information Dave, and I only dream of being in Las Vegas eating at the Valentino again.

The data is simply being imported from a file called sendapps.dbf into usertable.dbf. Then sendapps.dbf gets deleted. The process just keeps looking for sendapps.dbf to appear again. Once it does it imports the data again then deletes it...

I have tried a “wait "" timeout 3” after my program sees the new sendapps.dbf file. I am thinking that I am trying to append out of sendapps.dbf before it perhaps is completely written. Or maybe my usertable.dbf is just becomeing currupt from overuse.

I am using asp to pull the data out through an odbc connection so it can be displayed on a webpage, so while its opened exclusive, the asp has to wait for close, so it can read the data....

Thanks,

 

[DSummZZZ]

It's quite possible the sendapps table hasn't been completely transferred, or buffered data hasn't been completely written or flushed to disk.
Also, are you sure the file is getting transferred binary mode every time?
Maybe rather than a WAIT ... TIMEOUT, you could USE the temp file and do some checks on it. If nothing else, copy it to another temp file record by record to make sure the data is good or it doesn't error out.


-Dave Summers-

Even more Fox stuff at:

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

 

[lvadmin]

Thanks for the ideas Dave!

 

[lvadmin]

Just out of curiousity...
Does anyone know any database programs that repair your database for free. It seems that I find all these expensive programs however, none of them offer me a free trial period or even garauntee the repair.

Thanks,

Ross

 

[DSummZZZ]

You could give this site a try:

http://www.jjtc.com/Fox/foxfiles/

There are a bunch of utilities there.


-Dave Summers-

Even more Fox stuff at:

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

 

[keepingbusy]

Try this (they're free):

http://customsoftware.co.uk/csmain/downloads.htm

Good luck
Lee.....

Alone we can do so little, together we can do so much

http://www.customsoftware.co.uk