I have a Client server application written in excel VBA on Excel 97.
Before any changes can be made on the client, it must first check the see if any other changes are in progress by looking for the presence a "lock file" on the server on the network
If the file does not exist it is presumed that no other user is making a change and the file is then created to ensure no other users can make changes at the same time. This is then deleted when complete, thus freeing up the application for others to use.
The problem is the time it takes for a client open application to actually perform the open command (eg Open \\server_name\sharename\filename" For Output As #2), then do a simple 1 word write, then close it again.
Also Deleting this file (using the "kill") command, takes time.
They may only take a second or so each over the network, but when you have to look for the file, then create it, then delete it, every time a change is initiated, it slows everything down, and adds about a 3-4 second delay to the macro execution. This is not acceptable.
Does anyone have any suggestions as to another way to do all this. I need to be able to check, create and delete some sort of lock on a network server from a client.
Is it possible to create some sort of lock in memory in the server from the client, and then delete it, or check for it. Would this be quicker that using the file/creation method I am currently using.
And if so how do I do this.
Any suggestions would be greatly appreciated.