We have a user that wil enter the password for a shared folder. She clicks to remember the password. Once she enters the folder, she can access only one worksheet. If she closes the worksheet (but not the folder), and tries to open another worksheet, it will tell her that she does not have access. The only way that we can get her into the 2nd worksheet is to close the folder, reboot her computer, and enter the folder password again. There are several other users that do not have problems with the passwords on this folder. It is only the one user. Does anyone have any idea as to why this is happening? She sometimes has to reboot 5 times in 1 day, and it's starting to get very frustrating.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
shared folder password problems
- Thread starter christak
- Start date
christak,
Need some more info here:
1) Is the shared folder on the same machine as the user who is accessing it, or is it over the network? If it's on the network, is it part of a domain?
2) OS of all machines involved
3) Version of Excel (97, xp, 2003)?
Does it matter which spreadsheet is opened first?
Need some more info here:
1) Is the shared folder on the same machine as the user who is accessing it, or is it over the network? If it's on the network, is it part of a domain?
2) OS of all machines involved
3) Version of Excel (97, xp, 2003)?
Does it matter which spreadsheet is opened first?
- Thread starter
- #3
Need to be more specific about the OS stuff. Is your user's PC Windows 98? 2000? XP? Is the PC/server where the share is Windows 98? 2000? XP?
And again, does it matter which spreadsheet is opened first? For instance if you open sheet #1 first, then can't open #2, are you later (after rebooting) able to open sheet #2, and then sheet #1?
And again, does it matter which spreadsheet is opened first? For instance if you open sheet #1 first, then can't open #2, are you later (after rebooting) able to open sheet #2, and then sheet #1?
- Thread starter
- #5
Sorry again. The user's PC is Windows XP. The server is also XP. Is that the answer that you're looking for?
No, it does not matter which spreadsheet is opened first. No matter what, she can only open one spreadsheet at a time. When she tries to open a 2nd spreadsheet, she gets an error saying that she does not have access. Then we have to reboot.
No, it does not matter which spreadsheet is opened first. No matter what, she can only open one spreadsheet at a time. When she tries to open a 2nd spreadsheet, she gets an error saying that she does not have access. Then we have to reboot.
Your problem sounds like a tricky one.
If both machines are XP, then all of your file share users must be logging in with both an account name and a password, and I'm guessing, since you don't have a domain set up, that they're using an account or accounts set up on the file server. It would help to know if your other users are using the same account name to log on to the share as your problem user, but here are some things I would check:
1) make sure that there isn't an account local to your user's workstation that has the same name as the one local to the file server that she is using to log on to the share (if there is, having different passwords may cause problems)
2) make sure that all of the file permissions on the share folder and the spreadsheets allow that account access. These permissions are seperate from the share permissions.
3) I would create a test file, something other than an Excel file, and place it out on the share. Then, after your user opens the Excel file, see if she can open the test file. This will test whether the problem is a share level authorization problem or an Excel-specific problem. The test file could be anything - Word, text, etc.
The next time you have this problem, try this instead of rebooting: close the Excel file and the share folder on the user's workstation. To make sure the connection is severed from the workstation side, open a command prompt window and type "net use". If a connection to the file server still appears, use "net use \\<file server name>\<sharename> /delete". Now go to the file server command prompt and type "net sessions". If your problem user's connection still shows up, use "net sessions \\<workstation name> /delete". Once this is done on both sides, try re-opening the share from the workstation and seeing if you can connect to the second spreadsheet.
The net use and netsessions commans also might show an error message if there is a problem with the connection.
Good luck.
If both machines are XP, then all of your file share users must be logging in with both an account name and a password, and I'm guessing, since you don't have a domain set up, that they're using an account or accounts set up on the file server. It would help to know if your other users are using the same account name to log on to the share as your problem user, but here are some things I would check:
1) make sure that there isn't an account local to your user's workstation that has the same name as the one local to the file server that she is using to log on to the share (if there is, having different passwords may cause problems)
2) make sure that all of the file permissions on the share folder and the spreadsheets allow that account access. These permissions are seperate from the share permissions.
3) I would create a test file, something other than an Excel file, and place it out on the share. Then, after your user opens the Excel file, see if she can open the test file. This will test whether the problem is a share level authorization problem or an Excel-specific problem. The test file could be anything - Word, text, etc.
The next time you have this problem, try this instead of rebooting: close the Excel file and the share folder on the user's workstation. To make sure the connection is severed from the workstation side, open a command prompt window and type "net use". If a connection to the file server still appears, use "net use \\<file server name>\<sharename> /delete". Now go to the file server command prompt and type "net sessions". If your problem user's connection still shows up, use "net sessions \\<workstation name> /delete". Once this is done on both sides, try re-opening the share from the workstation and seeing if you can connect to the second spreadsheet.
The net use and netsessions commans also might show an error message if there is a problem with the connection.
Good luck.
- Status
Similar threads
- Locked
- Question