Oh, and if all that fails you could remove the table from the database, but if you use long fieldnames that could cause you more grief than you really need but in extreme circumstances I have done this and manually appended the data back into a new table.

Dave

-----Original Message-----

From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Russell

Sent: 27 September 2013 15:44

To: ProFox Email List

Subject: Re: How do you fix a dbc that opens with an error?

On Fri, Sep 27, 2013 at 9:22 AM, Dave Crozier <DaveC@flexipol.co.uk> wrote:

> use <old Table>

>

> Copy to <tablename> database <database Name> with cdx

>

> Where tablename and database name are fully qualified paths

>

> -----------------

>

That first line throws the error.

Use Shipments

Error has something to do with corrupted index or dbc corruption.

--

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

---

[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/18725B8CD2D5D247873A2BAF401D4AB22A3FD3EB@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.