CODEWITHSUNDEEP
sqlms-access
maxhugen
maxhugen

Reputation: 1944

MS Access: View SQL Insert statement for Linked Table

I'd like to see the SQL Insert statement created by Access from a Form, to a linked MySQL table.

Is there any way to view - or log - the SQL statement that Access creates?

Upvotes: 0

Views: 62

Answers (1)

Andre
Andre

Reputation: 27644

The alternative to the server log is to enable the ODBC driver log (aka Trace file).

5.8 Getting an ODBC Trace File

This can severely affect performance, so be sure to turn it off after getting the info you need.

Upvotes: 2

Related Questions