#163550 - 2006-06-23 05:12 AM
Share the Employee List
|
Ashpoint
Starting to like KiXtart
Registered: 1999-08-27
Posts: 192
Loc: Sydney, NSW, Australia
|
My client has created a Staff List of names, phone numbers, addresses and we store that as an Excel (2003) file in the Netlogon share on the server.
In Kix, I have a line (that works) that places the shortcut to the Excel file on each desktop
Code:
;******************** System Wide Staff List *********************
COPY "\\" + $HomeServer + "\Netlogon\" + $StaffListLnk $DocsPath + $UserID + $DeskTop + $StaffListLnk
In use, however, the users get a message that "Excel cannot access "Stafflist.xls". The document may be read only or encrypted"
Clearly there is a sharing error with the file and probably an Excel problem - not a Kix one.
However, I am sure others may have had a similar situation (publishing an employee directory) and I would be really interested in comment.
|
|
Top
|
|
|
|
|
#163551 - 2006-06-23 06:27 AM
Re: Share the Employee List
|
Kdyer
KiX Supporter
Registered: 2001-01-03
Posts: 6241
Loc: Tigard, OR
|
Quote:
My client has created a Staff List of names, phone numbers, addresses and we store that as an Excel (2003) file in the Netlogon share on the server.
If memory serves, it is considered poor practice in placing the Excel file on the NetLogon Share unless you want to grant rights to the users.. It would be better to be copied to an Application Server. One of the things that Excel does when you open it with Excel, is that it creates copies of the file you are working on in the same directory you are working in, especially when saving. If you ever have an Excel file crash, there is an opportunity to get the file it was working with, rename it and use it (I have personally seen this!) So, placing this on the Netlogon of the login server won't work. 
Kent
|
|
Top
|
|
|
|
Moderator: Jochen, Allen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Arend_, Mart
|
1 registered
(Allen)
and 1047 anonymous users online.
|
|
|
