Access linked to SQL database - how does it interact with the tables?

[Movian]

So we have an access front end with SQL backend and am trying to establish how access interacts with the SQL tables... if we have a form with a table as the data source when you close the form after making changes does it send an update query?

trying to figure this out so I can setup database triggers correctly and can't find a whole lot of info on this from google.

[jonh]

Are you talking about a normal access file or an adp?
I've never used an adp but have no reason to imagine a sql linked table in a normal access file wouldn't use the stardard events.

[Movian]

yeah its .adp

Will be doing some more testing this week and will see if it triggers the triggers.