On 2/18/2011 10:18 AM, Rafael Copquin wrote:

> What I do is this:

>

> set tablevalidate to 0

> set exclusive on

> open database........

> remove table ..... the one giving you trouble

> use ...... that table

> append blank

> go bottom

> delete (the blank record)

> pack

> use

> rebuild the indexes

> add table .....

>

> Once added, remember to change the primary key from candidate to

> primary, since it will be changed automatically to candidate when you

> remove the table from the database

Don't forget also that by removing it from the DBC, you'll lose long

field names, default values, validation rules, captions, and triggers on

that table.

--

Mike Babcock, MCP

MB Software Solutions, LLC

President, Chief Software Architect

http://mbsoftwaresolutions.com

http://fabmate.com

http://twitter.com/mbabcock16

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/4D5E91B0.6060507@mbsoftwaresolutions.com

** 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.