Gaining Remote Access to Microsoft Access with RDO - Create an ODBC source on XPHTEK
(Page 3 of 5 )
Since the RDO control connects through the ODBC connection, create a System DSN which connects to the database on the remote machine. For this, bring up the ODBC Data Source Administrator wizard from the Start-->All Programs-->Control Panel-->Administrative Tools--> Data Sources (ODBC) shortcut, which will open up the window shown below.
Click on the Add... button, which brings up the list of ODBC drivers available on the machine.
Highlight the Microsoft Access (.mdb) driver and click Finish. The ODBC driver on this machine is [ODBCJT32.dll], Version:4.00.6304.00. This brings up the next window where you will specify the DSN. You must give a data source name (DSN) and an optional description of the data source. The data source name for this example is NWonHodentek.
When you click OK to the above window you will be asked to locate the database, and you can find its location by bringing up the window Select database.
Since the database is on a network drive, you should bring it up by using the drop-down as shown. This will show the nwind.mdb file in the shared folder as shown. Another way would be to click on the button Network... which will open up the Map Network Drive window, where you can choose the network drive on which the remote database is situated, or browse to it.
Clicking OK to the screen will bring you back to the ODBC Microsoft Access Setup screen. If you click on the Advanced button you will see the information for this DSN as shown here.
After setting up a DSN for a remote database is complete, the ODBC Data Source Administrator window shows the System DSN, NWonHodentek as shown here.
Next: Visual Basic Application >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 6 
