If the database has a memo field in it, do not forget:
SET COMPATIBLE FOXPLUS | OFF | DB4 | ON [PROMPT | NOPROMPT]
Controls compatibility with Microsoft FoxBASE+ and other Xbase languages.
Arguments
FOXPLUS | OFF
(Default) These two keywords can be used interchangeably. Each allows programs created in FoxBASE+ to run in Microsoft Visual FoxPro without changes.
DB4 | ON
These two keywords can be used interchangeably. Including either keyword affects the behavior of the commands and functions listed below.
PROMPT | NOPROMPT
These options determine whether Visual FoxPro displays a dialog box when you open a dBASE table containing a memo field.
Include the PROMPT option to display the Convert Memos dialog box. If you open a dBASE table containing a memo field, Visual FoxPro by default displays the Convert Memos dialog box, which enables you to convert the dBASE memo file to a Visual FoxPro format. You must convert the memo file to a Visual FoxPro format to open the table in Visual FoxPro. You can later convert the memo file to a dBASE format by including the TYPE FOXPLUS option in the COPY command.
If you include NOPROMPT, the Convert Memos dialog box is not displayed when you open a dBASE table containing a memo field. The dBASE memo file is automatically converted to a Visual FoxPro format.
[sig]<p>David W. Grewe<br><a href=mailto

ave@internationalbid.net>Dave@internationalbid.net</a><br>[/sig]