won't accept new data

[dandrews]

I am running FoxPro 2.0 on a DOS machine off a Novell network. It has worked fine for years but has just begun locking up the computer when I add new data. Can you max out? Is it a memory issue? I tried to free up more conventional memory but it didn't seem to help or was still not enough.

dandrews [sig][/sig]

 

[dgrewe]

There are limits on the size of a dbf (2gig) and the number of records and the number of fields. However, My experience is that when a application locks up adding records, a cdx is damaged. Try grabbing the dbf exclusive and (Make a backup first)
set order to
copy to xxxx
then see if you can pack it or reindex it. If it locks up in the pack or reindex you will have to delete the cdx file and recreate it. [sig]<p>David W. Grewe<br><a href=mailtoave@internationalbid.com>Dave@internationalbid.com</a><br>ICQ VFP ActiveList #46145644[/sig]