Using Additional Software to View Date Remotely
Now that we’ve created a working distributed data collection and display system (see parts 1 through 4), let’s briefly explore other software packages available to access the database for both reading and writing. Here are two software packages you can use to read the data from the database (of course, they can write to it as well, but that is not part of this article).
We can use DASYLab to retrieve data from our MS ACCESS database. DASYLab is a graphical software package that does include ODBC support. With the help of CJ Butler, we were able to access the local database here in Massachusetts from her office in New Hampshire (about 100 miles!) using her VPN connection to an MCC server.
All she needed to do was map the Drive to her local computer, run the ODBC administrator on her local computer, and create the attached worksheet.