VBA Rubberducking

4:05 PM

I'm also aware that Microsoft has been plugging in security leaks inherent in SMB protocols, but the effect is that it breaks the assumptions around how the networked file work. Access is a canary in the coal mine in that regards. As a matter of fact, people reported a huge lockup due to one of security fixes which made Access files stored on network drives a single-user.

They've already patched it since but that was yet another incident in a series of incidents. So, yeah, we recommend that a RDBMS is used to hold and share data instead of a networked file. You really really want that strict librarian behind the desk.

FreeMan

IIUC, SMB 3 (I think) has so many breaking changes from v1 & v2 (and that the older versions have so many bugs/security issues) that the older versions are no longer on by default, and I'm not even sure they're installed by default. You have to go through great hoops to use them.

yet it was introduced in 2012-ish?

but then again, that adds up - the networking woes became more and more acute after Office 2010.

1 hour later…

Q: Excel VBA Hide Rows Based Upon List Selection Performance

5:39 PM

SMB is such an incredible mess that you shouldn't use it for accessing remote files anyways, but unfortunately it's basically the standard

Quack Exchange

I currently have a worksheet with approximately 40K rows and 108 columns that I am working with. What I am doing is creating a list that when user selects a particular text in that list then certain columns and/or rows are hidden. The issue I am encountering is that when 'Unsecured Streamline' is...

6:28 PM

@Vogel612, what is your preferred file share protocol? Is there something new that we should be using that isn't NFS? (MS support for NFS has always been a problem for me, I've always had to use 3rd party software to get it working)

6:44 PM

@HackSlash depends on what exactly you want to accomplish, but I see nothing specifically wrong with either proper Source Control.

Like... even normal people can learn to use SVN

which is basically a network share with a minor bit of stuff on top of it

and if you just want to have some files that people can read, I'd suggest using ftp

7:02 PM

Not familiar with SVN, but wouldn't that require one to do the equivalent of git pull to get other's changes?

2 hours later…

8:54 PM

Gleesh, you can't be talking about the 1971 FTP being a better option than SMB3... You must be talking about SFTP. Thanks for making me look because I never knew you could map an SFTP server as a network drive in windows. It requires some 3rd party software but this looks better than NFS: github.com/evsar3/sshfs-win-manager

github.com/billziss-gh/sshfs-win

#TIL

I wonder how well it handles locking & sharing, though.

definitely not going to try that with Access backend but Excel spreadsheet or Word document?

9:13 PM

OOF. It completely mangles multi-user environments. It's last write wins with no locks. So everyone is stomping on eachother.

So don't use mounted SFTP in a multi-user environment. I would rather get a lock error than suffer data loss due to write race conditions.

9:28 PM

Makes sense. FTP protocol doesn't really accommodate those scenarios.

10:02 PM

@HackSlash IINM there should be native support for FTP as a network drive

at least I recall setting up something like that

and I expect that the same holds for SFTP

SSH File Transfer Protocol

With plaintext authentication and no encryption?

SFTP is not FTP. It's completely different technology

In computing, the SSH File Transfer Protocol (also Secure File Transfer Protocol, or SFTP) is a network protocol that provides file access, file transfer, and file management over any reliable data stream. It was designed by the Internet Engineering Task Force (IETF) as an extension of the Secure Shell protocol (SSH) version 2.0 to provide secure file transfer capabilities. The IETF Internet Draft states that, even though this protocol is described in the context of the SSH-2 protocol, it could be used in a number of different applications, such as secure file transfer over Transport Layer Security...

sftptogo.com/blog/how-to-map-sftp-as-a-windows-10-drive

right, that's those 3rd party open source projects on github I linked

there also is a setup that doesn't need that tool

I'm not seeing it

There are 3 tools. Only one is optional, the key based auth