Quote:
|
Originally Posted by Shikha
Sub OnScanResult(SSID, BSSID, CapFlags, Signal, Noise, LastSeen)
rs.Open "INSERT into siteSurvey (position, MAC1_signal, MAC1_noise) VALUES (1,Signal,Noise)"
End Sub
|
Assuming you pasted your code into this message exactly, the problem is that you're passing string literals instead of the passed parameters.
Try this (obviously untested) instead:
rs.Open "INSERT into siteSurvey (position, MAC1_signal, MAC1_noise) VALUES (1," & Signal & "," & Noise & ")"