Hi. I am running the following code on two machines. On the machine that has Access it runs fine, but on the machine that doesn't have Access I get the error "Not a valid bookmark". Access was just copied as a .accdb file onto the machine that doesn't have MS Access. It has worked well for a year and suddenly this error
Dim sSQL As String
sSQL = "SELECT Info FROM Transactions WHERE TransactionID = " & sString & ""
If My.Settings.Setting_CompanyID <> "" And My.Settings.Setting_CompanyID <> Nothing Then
sSQL = sSQL & " And Co_ID = " & My.Settings.Setting_CompanyID
Dim connection As New OleDbConnection(My.Settings.CS_Setting)
Dim cmd As New OleDbCommand(sSQL, connection)
Get_Info_Field = cmd.ExecuteScalar().ToString