[AccessD] dBASE

I was able to pack and reindex (using the app's menu) and I still get the
syntax error:

http://davidmcafee.org/pics/dBASEerror.png

I'm not sure if that Rec 2433/2759 at the bottom indicates the trouble row.

I was able to export the two tables (Client and Services) to dbf files.
I can open them in Excel and I do notice that row 2434 is different, in
that it doesn't have a client name as well as most of the other fields in
the row.

I cleaned up the 4 or 5 similar rows and couldn't save as a dbf file.
Not sure if I could save as a text and re-import, or maybe I should try
looking for the troubled text in the DBF file via notepad.

Not sure what to do next.


On Wed, Jun 18, 2014 at 7:05 AM, Arthur Fuller <fuller.artful at gmail.com>
wrote:

> Not to boast, but not only was I a dBASE expert back in the day, I was also
> the first to publish an interview with C. Wayne Ratliff and Jeb Long. (But
> like everyone else, I moved to Clipper as soon as it was released.)
>
> Exactly how far can you get? Can you open the table itself, aside from via
> the app? It would be useful to know that much anyway. If you can, and
> following up on Jim's suggestion, Go Bottom and have a look at the last few
> records. Also, try packing the table, and if that works, then recreate the
> indexes.
>
>
> Arthur
> ​
>