I have a Windows 2000 machine that functions as a server to an intranet. It is W2K Pro - not W2K server - but it functins fine. When I go into Users and Passwords on this machine, I get a little check box at the top "Users must enter a username and password to use this computer."
I don't have it checked, so anyone can use the machine thru HTTP services, and can access the ASP's on the intranet, even though the Access DB's those ASP's use are on another server.
I am trying to upgrade the server, and I have another, better box to replace the old intranet. I installed IIS 5.0, loaded all the stuff from C:\inetpub\wwwroot, etc. , and tried going to the "new" intranet. I can get there with HTTP services, but when I go to view the intranet pages that go against Access DB's on other drives, I get the following:
"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data."
Now, the only differences between the boxes is that on the one that works, I don't need a login, and on the one that doesn't work, I do need a login. I think this is the rub, but I'm not sure. One last thing, when I power down the box that works, I don't have to log back in (It knows to reboot as Administrator), but I have to log into the other box. Is this a W2K issue (which I think it is), and, if it is, how to I effect the change on my new box to let users use it without logging in?