1 Replies - 513 Views - Last Post: 01 October 2015 - 12:00 PM Rate Topic: -----

#1 jielarth   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 27-September 15

external database driver Error 10023 from DBF file using Jet oledb

Posted 27 September 2015 - 01:10 PM

Hi,

Im in a real pickel, I have for the last few weeks been trying to work out a solution to write to a DBF file.
I have finaly got my solution to work using oledb jet4 to read the database into a dataset and then use
DAO recordset to move through the database and writing into the required field on each row. Works fine. On my computer, and one other the rest I have the above error "external database driver 10023"
error. I cant use VFP driver because it get a different error. I have a feeling it has all to do with the indexes, but cant confirm this. However the 2 machines that work are fine so the indexes cant be a problem. The other machine has no VB2005 instalation on it or other development tools.
What can I do ?

Is This A Good Question/Topic? 0
  • +

Replies To: external database driver Error 10023 from DBF file using Jet oledb

#2 vicenteweiss   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 01-October 15

Re: external database driver Error 10023 from DBF file using Jet oledb

Posted 01 October 2015 - 12:00 PM

Try opening the .dbf file in Excel or other program that supports opening the .dbf format.

Once opened in Excel you should be able to view the file, delete any "bad data", and resave to a new name (with the .dbf extension).

Also possible to create a new table with the structure of the old table, append records from the old to the new. May salvage records until the corruption is encountered.
In case the guide is uneffective for your situation, then your .dbf file is severely corrupted and can be restored by more powerful solution for such cases https://onlinefilere...air-online.html DBF files Online repair service
Also you may get more information on next threads about .dbf file corruption
http://www.idganswer...support-library
http://itknowledgeex...rupt-dbf-files/
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1