Microsoft Access
  Home arrow Microsoft Access arrow Page 4 - Gaining Remote Access to Microsoft Access ...
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Mobile Linux 
App Generation ROI 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
MICROSOFT ACCESS

Gaining Remote Access to Microsoft Access with RDO
By: Jayaram Krishnaswamy
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 6
    2006-05-16

    Table of Contents:
  • Gaining Remote Access to Microsoft Access with RDO
  • Remote data location
  • Create an ODBC source on XPHTEK
  • Visual Basic Application
  • Controls on the form

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Gaining Remote Access to Microsoft Access with RDO - Visual Basic Application


    (Page 4 of 5 )

    Adding a MSRDC Activex Control to tool box

    Start the Visual Basic Program (VB 6.0) on the Hodentek machine. Create a project, RemoteAccess.vbp, and add a form to it. Follow Project-->Components from the main menu to open up the Components window with three tabs, Controls, Designers, Insertable Objects. In the Controls tabbed page scroll down to place a check mark for the Microsoft RemoteData Control 6.0 as shown, and a check mark for Selected Items Only, and click OK. This adds the ActiveX control MSRDC20.OCX to the tool box, a small icon with an antennae which shows 'MSRDC' when you hover over the icon.

    Properties and Methods of MSRDC

    The properties and methods of this object can be reviewed in the Object browser as shown here. The data source name of this control is the one that was configured earlier.

    More Microsoft Access Articles
    More By Jayaram Krishnaswamy


       · Is this the same RDO that preceded ADO and we all used back in 1997? It was great in...
       · You have one up on me. OK. You are right, RDO will not be supported in the future....
     

    MICROSOFT ACCESS ARTICLES

    - Linking SQL Express 2005 Tables to MS Access...
    - Working with Access Projects in Access 2007
    - Exploring Access 2007
    - Working with Stored Procedures in an MS Acce...
    - Creating and Using Action Queries
    - Creating Data Access Pages with Charts using...
    - Advanced Ideas using VBA
    - VBA Details
    - Updating Records in MS Access
    - Using ADO`s Record Object with URLs
    - Exporting XML from MS Access 2003
    - Importing XML into MS Access 2003
    - On Using Pass-through Queries in MS Access
    - Distributed Queries in MS Access
    - Configuring a Linked Microsoft Access Server...





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway
    Stay green...Green IT