Thursday, February 16, 2012

Access Linked Tables, monitoring SQL

We have a table that is populated via Access linked tables with forms bound
to it. When monitoring the table(or all SQL against the database) I don't
see any of the commands (CRUD) against this table. I beleive that
client-side cursors are used in this scenario? I'm depsarate to see the SQL
as we have disappearing data. Any thonughts or suggestions?
Have you tried a Profiler trace? That will show you the commands that
Access is executing against the server.
--Mary
On Thu, 18 Jan 2007 09:01:03 -0800, Jeff Ericson
<JeffEricson@.discussions.microsoft.com> wrote:

>We have a table that is populated via Access linked tables with forms bound
>to it. When monitoring the table(or all SQL against the database) I don't
>see any of the commands (CRUD) against this table. I beleive that
>client-side cursors are used in this scenario? I'm depsarate to see the SQL
>as we have disappearing data. Any thonughts or suggestions?

No comments:

Post a Comment