The code executed without errors; however, the data did not update in the MS Access database table using Python

Using Streamlit
,
1

The code ran without any errors; however, I encountered an issue where the data did not update in the MS Access database table using Python. It displayed the correct data after executing the connection commit command, but when I reopened the app, it showed the previous data without any updates. Could you please take a look at my code and provide your best guidance on how to properly save data in the MS Access table? Thank you in advance for your assistance!

import streamlit as st
import pyodbc
import pandas as pd
conn_str = (
r’DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};’
r’DBQ=C:\iqra\mfa.accdb;’
)
connm = pyodbc.connect(conn_str)
cursorm = connm.cursor()
query = “SELECT * FROM Payments”
dataf = pd.read_sql(query, connm)
print(dataf)
i_want_to_multiply = 2
filtered_rows = dataf.loc[dataf[‘Payment_ID’] == 20]
filtered_rows[‘Gross_Pay’] = 100
print(filtered_rows)
sql = ‘’‘UPDATE Payments SET [Gross_Pay]=? WHERE [Payment_ID]=? ‘’’
for index, row in filtered_rows.iterrows():
print([row[‘Gross_Pay’], row[‘Payment_ID’]])
cursorm.execute(sql, [row[‘Gross_Pay’], row[‘Payment_ID’]])

cursorm.commit
connm.commit
query = “SELECT * FROM Payments”
dataf = pd.read_sql(query, connm)
print(dataf) # give update data or

cursorm.close()
connm.close()

1 Like