Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TMP renamed tables
Message
From
05/07/2010 13:17:34
Bruno Maddalozzo
Informatica Aziendale
Arsie, Italy
 
 
To
05/07/2010 10:26:12
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01471379
Message ID:
01471422
Views:
44
>Does the NAS support multiuser-locking in databases and Opportunistic Locking? Is it configured to do so?

How can I verify that?
Thank you.
Bruno



>>A client of mine reported a weird problem.
>>The scenario:
>>- Application and data are located on a mapped drive Z:\ which is a Nas (i.e. 192.168.1.20) accessed by three computers.
>>- Data are like: TableMaster.dbf (plus TableMaster.cdx), TableDetail.dbf (plus TableDetail.cdx).
>>After an insert, through the applicazion form, data got corrupted like that:
>>TableMaster.dbf became 5EFC00K.TMP
>>TableDetail.dbf became 5EFC00L.TMP
>>While CDXs stayed with the correct name: TableMaster.cdx + TableDetail.cdx.
>>To solve, I had to manually rename
>>5EFC00K.TMP -> TableMaster.dbf
>>5EFC00L.TMP -> TableDetail.dbf
>>Besides, overwrite CDXs with empty ones, then reindex.
>>The question: which may be the explanation for such a problem?
>>How to prevent from occourring again?
>>TIA.
>>Bruno
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform