Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unable to create new entries
Message
From
17/08/2005 20:54:24
Jill Derickson
Software Specialties
Saipan, CNMI
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Unable to create new entries
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01041825
Message ID:
01041825
Views:
58
[Also posted on VMP board.]
Hi,

I have a large table, MASTER.DBF, with over 95,000 entries. The network is Win 2000, VFP 9.0, latst VMP.

Some users are only updating data and one or two users may be creating new entries. Periodically (4 times in the last 2 weeks, since I've installed their system, here in Pohnpei, FSM), we have had a problem that the user entering new records is unable to save the entry. The user can log back in and make updates, but from then on no further new records can be added.

We've tried rebooting the user's computer and entering on another computer, but from then on, no new entries can be added until the file is reindexed (we use Stonefield).

Other users can still MODIFY information, just no new entries can be created.

Looking at MASTER.DBF, i don't see any corruption. I don't get any errors on VALIDATE DATABASE. The table has 30 indexes.

I'm using table optimistic buffering. Only 1 table would be updated on a new entry.

Any suggestions/help on anything i can do to prevent this?

Any help/input is appreciated...I'm supposed to go home on Saturday! thanks, j
Next
Reply
Map
View

Click here to load this message in the networking platform