RE: Event when Access table is accessed through ODBC ?
- From: dch3 <dch3@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 8 Aug 2008 12:46:01 -0700
Access does not support triggers. At the table level, Access has no way of
knowing that anything at all has been done to the records.
Access is a file-based database which means that all data is stored in a
file and its up to the application running on your PC to work with it. A
Client-Server database has two parts - the part on the PC (Client) that makes
the request to the server. Only Client-Server databases, such as SQLServer,
Oracle, etc, support triggers.
"Sverk" wrote:
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,
- Follow-Ups:
- References:
- Prev by Date: RE: Event when Access table is accessed through ODBC ?
- Next by Date: Return Value From Recordset - Using Variable as Field Name
- Previous by thread: RE: Event when Access table is accessed through ODBC ?
- Next by thread: RE: Event when Access table is accessed through ODBC ?
- Index(es):
Relevant Pages
|
