Hi

I am trying to get data from a remote users cut so I can compare it to data we have on the main server.  We are using access to connect to the remote cut using one of the following connection strings

'connUser.Open "Provider=sqloledb;Data Source=LG35044083;Initial Catalog=SLXRemote;Integrated Security=SSPI;User ID = ; Password = ;" 
'connUser.Open "Data Source=.\\SQLExpress;Integrated Security=true;" & _
'              "User Instance=true;AttachDBFilename=|DataDirectory|\SLX_KM75179_dat.mdf;" & _
'              "Initial Catalog=SLXRemote;"

'connUser.Open "Provider=sqloledb;Data Source=,1433;Network Library=DBMSSOCN;Initial Catalog=SLXRemote;User ID=assword=;"

connUser.Open "Provider=sqloledb;Data Source=\LG35044083;Initial Catalog=SLXRemote;Integrated Security=SSPI;"

'connUser.Open "Provider=MS Remote;" & _
' "Remote Server=LG35044083;" & _
' "Remote Provider=SQLOLEDB;" & _
' "Data Source=LG35044083;" & _
' "Initial Catalog=SLXRemote;" & _
' "User ID=" & _
' "Password="

I do not get any error messages when using any of the connection strings above but my access table is getting blank values through.  Any help please

Code below so you get the idea of what I am trying to do

Dim strGetId As String
strGetId = "SELECT HistoryID from sysdba.HISTORY"

Set rst = CreateObject("ADODB.Recordset")
     rst.CursorLocation = adUseClient
     rst.Open strGetId, connUser, adOpenKeyset, adLockBatchOptimistic
     rst.MoveFirst
     'Debug.Print rst("HISTORYID")
    
Set rstDB = db.OpenRecordset("userHistory")

i = 0
    
While Not rst.EOF
    
    rstDB.AddNew
    MsgBox rst("HISTORYID").Value
    rstDB("HISTORYID").Value = rst("HISTORYID").Value
    rstDB.Update
   
    i = i + 1
      
    rst.MoveNext
Wend

strGetId = "SELECT HistoryID from sysdba.HISTORY"
If you are using the SLX OLE DB Provider, not need to use sysdba.

rst.CursorLocation = adUseClient
rst.Open strGetId, connUser, adOpenKeyset, adLockBatchOptimistic
I thought you said this would be READ ONLY?

rst.MoveFirst
I thought that an RS.Open automagically moved you to the first record as your cursor?

Do a record count right then and there on rst and prove how many records you have. If it's less than 1 full stop.

Set rstDB = db.OpenRecordset("userHistory")

?? what is DB? I don't have a clue what you are doing here....what connection? OpenRecordset?

On the connection string, I'd create an actual datalink file and then copy the connection string from there.....often times the SLXRemote database is in a named instance like SalesLogix\SLXRemote or SQLExpress\SLXRemote.....