Question Systems gets locked after 5Min

[asif pasha]

Hi All,

Please help me out on this.
We have a file which needs attention morethan 5min continuesly without any movement. And badly system gets locked after 5min. Just thinking if i can build some VB script or an access file so that system doesnt get locked.

Thanks in advance.

 

[DCrake]

A clearer explanation would be more informative please.

 

[asif pasha]

A clearer explanation would be more informative please.

Hi DCrake,
Thanks for replying.

We normally work on excel sheet, which has a huge data in it. We need to understand and investigate the line entry. For your information the entry which we find in excel sheet is accounts entry, for that to understand we need help from other colliques.

What i am thinking is to build a macro which acts interface with system time. Each time which i run a macro the code should do something that system shouldn't get locked after 5 min.

Hope you got an idea what i am thinking.

Thanks for your time.

 

[gemma-the-husky]

excel sheets get locked for users other than the first user only.

access is not the same as excel. that is probably the issue.

 

[asif pasha]

excel sheets get locked for users other than the first user only.

access is not the same as excel. that is probably the issue.

I know, but i am thinking of writing a code in access form, where the time interval gets capture, and every 5min of time interval it should pass something like moving the curser up and down so that the system doesnt get locked.

 

[Insane_ai]

Check the Shared workbook advanced tab. The update changes function may be getting overwhelmed. You may be able to delay the interval but solving the problem may lie in converting to a database.

 

[gemma-the-husky]

I know, but i am thinking of writing a code in access form, where the time interval gets capture, and every 5min of time interval it should pass something like moving the curser up and down so that the system doesnt get locked.

if the spreadsheet is read only to most users, this wont be fixed by moving the cursor, I don't think.

 

[asif pasha]

if the spreadsheet is read only to most users, this wont be fixed by moving the cursor, I don't think.

Alright, i think i need to simplyfy my question.

Basically what i am looking is system shouldnot get locked after a time interval i.e 5min.

 

[Insane_ai]

If the system is getting locked, it is a power setting. Ex: "This Computer is in use and has been locked..."

Check the display settings:
Screen Saver tab | On resume password protect option

 

[asif pasha]

If the system is getting locked, it is a power setting. Ex: "This Computer is in use and has been locked..."

Check the display settings:
Screen Saver tab | On resume password protect option

I need those settings to, only if i lock the system manually, because if i wont give the password to unlock system then anyone can access my files when i am away from the system.