u/Trax256

Still searching for a solution, Have looked at and the main drawbacks:

OneDrive - Everyone says that Sync is kind of problematic and can be a resource hog

Browser access - can only open select files with Desktop apps

Netdrive - Horrid. No support, the documentation is terrible and doesn't seem to work

This is in a business environment with 20 workstations, so I really want something that is business class and reliable. I guess it kind of surprises me that everyone is moving to the cloud, yet there doesn't be any kind of consensus in how to access the files once they're in the cloud. Have I missed looking at a solution?

This has been a romp through hell. We currently have a Windows Server 2019 Standard and 20 Windows 11 workstations. For some reason, unbeknownst to me, the decision was made to move all of our files and folders to the cloud and get rid of our on premise server. I kind of posted what was going on and asked if everyone thought that was a good move and the response was overwhelming. Yes, yes. Move to the cloud. Move to the cloud.

So my predecessor started migrating things to Sharepoint Online. Really long story really short, there doesn't seem to be a good way to access these files and folders once they're up in the cloud. No one likes Onedrive. They said there are too many problems with it sinking. Accessing the files and folders with the browser has more drawbacks than I even want to talk about. Today I sat down and tried to look for utilities that would let you map a drive letter to Sharepoint Online. The de facto standard was supposed to be net drive, but I gotta tell you, I can't believe they're charging for that. It's a total and complete train wreck.

I guess we're a little too far in to Sharepoint Online to bail. Does anyone have any recommendations on a super good way to access Sharepoint Online from a Windows 11 computer? Onedrive kinda sucks. Night drive kinda sucks. To be honest I wish they would have kept their on premise server and just kept using VPN access for remote stuff but that would make too much sense. With this mass exodus to the cloud, there has to be something out there that's relatively easy to use, isn't there?

I figured I better start a new question on this one. The original question is kind of all over the place. I was told that if I went into the Sharepoint Online library and clicked on advanced settings and change the default to open in app That it would no longer prompt you how you wanted to open it. If you clicked on an Excel file, it would open it in Desktop Excel. Unfortunately, it doesn't. When I just click on an Excel file, it opens it in the cloud version of Excel. What I was hoping it would do is open it in the desktop version of Excel. Not the online version. Is there any way to accomplish this?

I might have been warned about this. I have a folder called "files". Under that folder is a folder called "accounting" and under accounting there is a folder called "payables". The boss wanted to give an employee access to payables, yet still did not want to give them access to accounting. So I granted this employee access to payables. Lo and behold, it did not show up In File Explorer. My guess is going to be that since they had no access to accounting, they can't see anything below accounting. Would that be a good guess? Is there any way around this? Where you give someone access to a sub folder but not to the folder above it?

Right now I have 20 Windows 11 workstation formally joined to a 2019 Standard Server network. The DNS value on all the workstations is the IP of the Windows Server.

We are slowly migratin computer to an Azure AD domain. When I disjoin a workstation form the Server 2019 Domain and join it to the Azure Domain the IP addresses stay the same because the Windows Server is the DHCP.

The problem is that none to the Windows Domain computers can see the Azure Domain computers. The Azure Domain computers aren't showing up in the Windows DNS Server. So my first thought was to allow non-secure updates to the DNS which should allow the Azure computers to register with the Windows DNS. But they still done register in the DNS. I did a Ipconfig release and register. Still not joy. So I guess two questions:

1. What won't the Azure Computers register in the Windows DNS?

2. I can ping 2 Azure computers but they still don't show up in the Windows DNS. Where are the getting their name resolution? It isn't in the Reverse Lookup Zone. We don't use WINS. No ones hosts file has been modified. WHere is the resoltion coming from?