ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent Locked for Editing on a network (https://www.excelbanter.com/excel-programming/285801-prevent-locked-editing-network.html)

bat_man2282

Prevent Locked for Editing on a network
 
Hi guys,

I have read quite a few posts regarding the "Locked for Editing by use
' ' " issue, but I have a slightly different problem. We are using
custom designed template which multiple users can access at once. N
user can change the template, but multiple users can change the data i
the database (and thereby have the template open at the same time).
However, about a week ago we started getting an error message when mor
than one person is trying to access the template. We need to allo
mutiple people to have access at the same time. Does anyone have an
idea why we are seein this issue all of the sudden... is it a serve
issue... and is there away to code around it? Any help would b
greatly appriciated.

Cheers,
Dav

--
Message posted from http://www.ExcelForum.com


Tom Ogilvy

Prevent Locked for Editing on a network
 
Is the file set as readonly when you look at its properties in Windows
explorer. If not, try setting it to read only.

--
Regards,
Tom Ogilvy

"bat_man2282" wrote in message
...
Hi guys,

I have read quite a few posts regarding the "Locked for Editing by user
' ' " issue, but I have a slightly different problem. We are using a
custom designed template which multiple users can access at once. No
user can change the template, but multiple users can change the data in
the database (and thereby have the template open at the same time).
However, about a week ago we started getting an error message when more
than one person is trying to access the template. We need to allow
mutiple people to have access at the same time. Does anyone have any
idea why we are seein this issue all of the sudden... is it a server
issue... and is there away to code around it? Any help would be
greatly appriciated.

Cheers,
Dave


---
Message posted from http://www.ExcelForum.com/




bat_man2282[_2_]

Prevent Locked for Editing on a network
 
NO, then file is not set to read only.


---
Message posted from http://www.ExcelForum.com/


bat_man2282[_3_]

Prevent Locked for Editing on a network
 
Does anyone have an answer to thi

--
Message posted from http://www.ExcelForum.com


Tom Ogilvy

Prevent Locked for Editing on a network
 
If not, try setting it to read only.

--
Regards,
Tom Ogilvy

bat_man2282 wrote in message
...
Does anyone have an answer to this


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 11:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com