I'm converting an app to Access 2010 and getting a compile error: data member not found. Following is the code.
Public Function ServiceProcessSet(UserID, ServiceID, ProcessType) As Boolean
Dim tmpUserID As Variant
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("SELECT * FROM sysUsers INNER JOIN tblContact ON sysUsers.UserID = tblContact.ContactID WHERE ServiceID = " & ServiceID)
If rs.RecordCount > 0 Then
rs!ProcessType = ProcessType
DoCmd.RunSQL ("INSERT INTO SysUsers(WSID,UserID,ServiceID,DateStart,ProcessType) SELECT '" & GetWSID() & "' as WID," & UserID & " as UID, " & ServiceID & " AS SID, '" & Now & "' AS start,'" & ProcessType & "'")
The error happens on the rs.edit statement. Does this mean that the frontend needs to have the backend tables linked before the compiled? The table referenced, SysUsers, is a linked table that is shared among all the apps on various workstations. This routine is run during startup.
Or is there something else wrong?
Thanks for your help.