MS Access VBA module for ODBC connected tables

Question

Hello Everyone,

Before migrating my Access table to SQL, my module was working great, but now after the migration and linking back while using the same frontend Access form, I got this message. The mode still returns the results what I needed, but here is the screenshot of popping message every time I open it.

It says, I must use 'dbSeeChanges' option with OpenRecordset. The below module shows yellow highlighted line where the error is. How should my module look like?

Need help. Thank you and appreciate your inputs.

Answer 1

Resolved!

I rewrote the code as

Set rstRecord = db.OpenRecordset (strSQL, dbOpenDynaset, dbSeeChanges)

Thank you