339784_en-US

liliconcom

How to prompt a " File in Use" message

Hi,

 

I'm currently creating a JMP file which acts as a database. Therefore I would like to prompt a "File in use" message and keep the file locked for editing when someone else already opened the database and is making changes to the file. For example, the same message you get when you open an Excel file on a server location that is already in use by someone else:

 

 

 

 

 

I think I already found a part of the answer in the following Community post: Multi-User Access 

 

If I'm correct I would still need to figure out how to lock the table if it is opened by another user.

 

Could someone please help with creating such a script?

 

Thanks

 

Data TableScriptingRe: How to prompt a " File in Use" message

A JMP table is locked for writing by the first user that opens it. Subsequent users get read-only access (they can't save their changes). The script @David_Burnham wrote assumes the user with the lock will close the table fairly soon (200 tries) and then opens the table for the new user, which should get the lock for the new user. It might work pretty well for 2 or 3 users that use a carefully written program to update the table. It is not for a user that might open the table then go to lunch without closing it.

Re: How to prompt a " File in Use" message

Thanks for the respons Craige.

 

Would it be possible to prompt a message/warning that the file is already in use by someone else? Currently, the second user could be unaware that the file is already opened by another user. So if the second user makes any changes to the file, these changes cannot be saved to the orginal file.

Re: How to prompt a " File in Use" message

David's script has the code that checks for the visible indication:

Several copies of JMP open, same table in two copies, one of them is locked out by the other.

Re: How to prompt a " File in Use" message

Hmm. I can see it works in JMP 14, but maybe not 15.