

We will be using Microsoft Access, so select ‘Microsoft Access Driver (*.mdb, *.accdb),’ then click Finish. User DSN means that only you will be able to access this data source, and System DSN means that anyone who is on the machine should be able to access the data source (though only if they provide the necessary credentials).

Click on Start> Control Panel > Administrative Tools, then double click on "Data Sources (ODBC)". You will need to put an ODBC connection on the computer you're working on.
Windows universal database how to#
There are a lot of 'step by step' instructions on how to accomplish this on the internet, just Google “How to set up an odbc connection.” In lieu of that, here are my 'step by step' instructions (as performed on Windows 7/64 bit). Or more properly stated, adding an ODBC connection to the computer you are working on. Part 5: Using other packages to view the data remotely Part 4: Dispersing the application to view the data remotely Part 3: Creating the application to view the data with VB.NET Part 2: Creating the application to collect the data with VB.NET We will be using Microsoft Visual Basic.NET 2010, Microsoft Access 2013, Measurement Computing Universal Library, a USB-2408 for data collection, and BERGtools for the graphics. This application will not teach you everything you want or need to know about databases, nor is that its intention. We will create a Visual Basic.NET application capable of reading data from a USB-2408 using the Universal Library, writing the generated data to a Microsoft Access database on a separate computer or server, and then with another Visual Basic.NET application, read the generated data and display it graphically. Why would you want to do that? The problem to solve is “In near real time,how to read generated data remotely on multiple computers without them getting in the way of each other?” The answer is, you do this by writing the data to a database. In all there will be 3 computers spanning this application,one to generate the data, one to store the data and one to read the data from afar. This application note will span 6 knowledge base articles.
