RE: Event when Access table is accessed through ODBC ?

OK, thanks, I see.
Then I figure I might get my thing done by having IMatch not just making a
Read but also an insignificant Update to the record in the Access table, just
to trigger the code in there.
Thus what you say, "Client-Server based databases allow you set Triggers on a
table (code that executes when a record is INSERTED, UPDATED or DELETED)",
that could be what I need.
Could you please indicate how to set up such a trigger?
Is there a special way for such triggers?
Or would it simply(???) be like if the table is open and showing in a form
there would occur a useful form-event whenever a record in the table is
updated through ODBC?
Would it then also indicate which record was updated?
All help appreciated,
--
Sverk


"dch3" skrev:

Sorry, but there are no table-level events. Its only at the form or report
level. Also, while Client-Server based databases allow you set Triggers on a
table (code that executes when a record is INSERTED, UPDATED or DELETED),
there's nothing to my knowledge that checks when a table is being otherwise
accessed - as in Read. That'd be more of a function of the engine driving the
database.

"Sverk" wrote:

Hi,
I have an Access 2007 table of photo-films and I use IMage for handling of
digitized photos.
I need to link these two applications in certain ways.
From IMage I am able to access the Access table through ODBC, read and
update etc.
Fine, and next thing is to get Access to synchronize with these ODBC calls.
Whenever IMage calls on a record in the Access table, I want Access to
display that record in a form, or something like that.
So here are my questions:
Assuming the Access database is open, what I need is an event that gets
triggered when it is accessed from another application through ODBC.
Is there any? Where do I find it?
And, how do I know in the Access code which record is being accessed?

See what I mean?
Help please,





.

Relevant Pages

  • Re: Use replication + DTS - Referred to Hilary Cotter or Paul Ibison
    ... Hilary Cotter ... Looking for a SQL Server replication book? ... I can't> use replication services because the tables and columns between databases are> different. ... Or can> I use triggers to run between the two databases and accomplish this? ...
    (microsoft.public.sqlserver.replication)
  • Re: Use replication + DTS - Referred to Hilary Cotter or Paul Ibis
    ... idOrder, comments etc.... ... >> I have two seperate databases with different table names and column names. ... >> running a scheduled dts package the best way to accomplish this task. ... >> I use triggers to run between the two databases and accomplish this? ...
    (microsoft.public.sqlserver.replication)
  • Re: Best Practice synchronizing data
    ... I am fairly new to the forums (Ask on the replication NG - ... would using triggers to activate DTS be as intensive as just ... If not how do I activate a DTS package with a trigger. ... >>I have two seperate databases with different table names and column names. ...
    (microsoft.public.sqlserver.dts)
  • Use replication + DTS - Referred to Hilary Cotter or Paul Ibison
    ... Cotter or Paul Ibison. ... You could use replication + DTS (Ask on the replication NG - Hilary Cotter ... I have two seperate databases with different table names and column names. ... I use triggers to run between the two databases and accomplish this? ...
    (microsoft.public.sqlserver.replication)
  • RE: Event when Access table is accessed through ODBC ?
    ... Access does not support triggers. ... Client-Server database has two parts - the part on the PC that makes ... Only Client-Server databases, such as SQLServer, ... updated through ODBC? ...
    (microsoft.public.access.modulesdaovba)