Connection to Access database with Mobile 6.5

Discussion created by cam.kenny on Mar 22, 2012
Latest reply on Mar 23, 2012 by cam.kenny
I have an ArcPAD application that was developed back in 7.x that is programmed using vb.  I use a connection string to connect to the access database to store my attributes.  Connection was done using ADO and worked quite well, both for the full windows install and also the CE versions (back in the day).

Here is the connection string(s):

' Windows 95/98/NT/2000
   Case 1, 2

    Set objConnection = CreateObject("ADODB.Connection")
    objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDataPath & "AgCapture-CPEd.mdb"
    Set rstLandOwnerTbl = CreateObject("ADODB.recordset")

   ' Windows CE
   Case 3
    Set objConnection = CreateObject("ADOCE.Connection.3.1")            
    objConnection.Open strDataPath & "AgCapture-CPEd.cdb"
    Set rstLandOwnerTbl = CreateObject("ADOCE.recordset.3.1")

Can someone please help me out to setup a connection string using much the same technology but for Windows Mobile 6.5?