Connection to Access database with Mobile 6.5

03-22-2012 07:48 AM
New Contributor
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?
Tags (3)
0 Kudos
2 Replies
Esri Regular Contributor
Cam, what version of ArcPad are you using now?

0 Kudos
New Contributor
I am currently using 7.0.1 but also have 10 and the windows connection works with 7 all the way to 10 on both xp and windows 7

I am not committed to using ado but it is what I know right now 🙂
0 Kudos