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: [email protected] 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/[email protected] ** 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.
