Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Packing tables in a multiuser environment
Message
From
23/06/2000 02:15:36
Walter Meester
HoogkarspelNetherlands
 
 
To
23/06/2000 01:57:29
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00383626
Message ID:
00383628
Views:
13
Chris,

>I want to write a routine to pack tables in a multiuser environment. I want the code to see if there are any other users on the system and if not open the tables exclusively and perform the pack. How do I determine if a table is in use by other users (without using error trapping)?

Error trapping is definitely the most easy way, but if you want to check the numbers of users or the usernames who have used the file, you might look at the NetFileEnum API call in the FAQ: 'Who opened what files on the network?'

This however does not give you a guarantee that if no-one has used the file you'll still be able to open it exclusively after you checked. IMO you're better off with handling any errors

Walter,

>TIA
Previous
Reply
Map
View

Click here to load this message in the networking platform