Stephen,

In that case it is either a DBC error or a table index error.

For Table error (cdx corruption) take a backup first then copy an old CDX over the existing one. Then run open exclusive and reindex.

For DBC error you can try the "database validate" command or the same thing as above (which is extreme) but using the .dcx database index

Then do a database validate

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