I am trying to run an insert query using the following code:
DoCmd.RunSQL "INSERT INTO Software ( PCID, Name, Version ) VALUES ( '" & Me.txtPCID & "', '" & CStr(lngSoftware) & "', '" & CStr(lngVersion) & "');"
The program loops through the registry extracting software information and runs the...