Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

HOW TO KNOW IF THE DBF FILE CORRUPTED OR NOT


  • Please log in to reply
1 reply to this topic

#1 carmelobeach

carmelobeach

  • Members
  • 1 posts
  • OFFLINE
  •  
  • Local time:02:05 PM

Posted 30 May 2015 - 11:01 AM

hi all

i have ms access procedure for importing dbf files into ms access

but i face a problem with corrupted files

is there any code to detrmine if DBF file is corrupted or not to make exception for it ?



BC AdBot (Login to Remove)

 


#2 olliesharp

olliesharp

  • Members
  • 1 posts
  • OFFLINE
  •  
  • Local time:02:05 PM

Posted 30 May 2015 - 03:52 PM

As a variant try next step:
Copy a valid memo file over the corrupt memo file to access the database again. 
 
NOTE: The original memo field information will be lost unless the valid memo file was an exact backup of the corrupt file. All memo field backup files have an extension of .TBK. 
 
The corrupt memo file will have an .FPT extension, such as OLD.FPT. In the following example, assume NEW.FPT is a valid memo file. To bypass the error message and access the database again, type the following command at the MS- DOS command prompt:
 
Copy new.fpt old.fpt
 
more info about methods for dbf restoration see on





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users