I have a question about using Access connecting to an DSN less ADODB connection to a MSSQL Database on the web. I need to get a feel for how secure it is. Perhaps you could give me opinions and references.
I realize that nothing is REALLY Secure on the Web, I just looking for a reasonable application of security.
I'm wanting to store Sales information - no Socials or Credit Card Numbers.
I'm writing unbounded forms that connect via ADODB to an MSSQL Database located on the web to populate the form..
There's no Sales Data in the application. The username and password to connect to MSSQL are input by the user when the app starts. This is in Access 2007 and will be finally saved as an ACCDE file extension.
How does this setup look to you gurus and any suggestions?
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!