Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Check to see if a file is open
Message
 
To
09/05/2007 18:44:46
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01223969
Message ID:
01224019
Views:
17
Hi John,

Well, sadly, I have to ZAP the table each time that I update it from a spreadsheet which is created by our AS400 with the latest orders. This is why it has to be an exclusive open.

>Cecil, I was going to propose try...catch again until I saw the VFP6 comment...

>Just for interest, why do you need exclusive access? If there is a chance the target table is in use by others, could you bring the excel spreadsheet into a temporary repository and do a SCAN...INSERT...ENDSCAN?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform