my problem:
Dim EName As String
EName = "Stanich JR, James A"
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=" & TimeDatabase
rst.Open _
"Select EmployeeFull from Employee_Info where_ EmployeeFull='" & EName & "'"" _
, cnn, adOpenStatic, adLockPessimistic
I keep getting a syntax error.
Any suggestions?




Reply With Quote