RE: Event when Access table is accessed through ODBC ?
- From: dch3 <dch3@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 8 Aug 2008 10:33:00 -0700
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: DBEngine.CompactDatabase vs Compact on Close
- Next by Date: Re: Cannot update DAO Recordset
- Previous by thread: Event when Access table is accessed through ODBC ?
- Next by thread: RE: Event when Access table is accessed through ODBC ?
- Index(es):
Relevant Pages
|
