'Exception occurred.', (0, 'Microsoft JET Database Engine', 'No value given for one or more required parameters.'
Expand|Select|Wrap|Line Numbers
- def linker (Function):
- conn = win32com.client.Dispatch(r'ADODB.Connection')
- DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=db8.mdb';
- conn.Open(DSN)
- rs = win32com.client.Dispatch(r'ADODB.Recordset')
- rs.Open("SELECT MAX(COID) as ID from SYS", conn)
- NewID=rs.Fields("ID").Value+1
- strNewID=str(NewID)
- conn.Close()
- sql_statement= "INSERT INTO Table1 (Comp, Fam) VALUES (" + strNewID + ", '" + Function + "')"
Any ideas?