|
Home > Archive > MS Access Multiuser > April 2005 > last time a record was edited
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
last time a record was edited
|
|
| Joanthan 2005-04-06, 8:06 pm |
| Is there a built in property in Access/ Jet that can give me a Date/Time of
the last time a record was edited, added or deleted from a table?
I.e. A Last Modified property on the records of a table, not on an open
recordset and not on the Tabledef itself?
Thank you
| |
| Rick B 2005-04-06, 8:06 pm |
| No. There is no built-in function.
Do a search for "timestamp" and you will find many many previous posts that
address methods to do this.
You should always search before posting a new thread. 9 times out of 10 you
will find your answer.
Rick B
"Joanthan" < Joanthan@discussions
.microsoft.com> wrote in message
news:2C5E0EE1-17F9-4E6A-BD14- C50399522F71@microso
ft.com...
> Is there a built in property in Access/ Jet that can give me a Date/Time
of
> the last time a record was edited, added or deleted from a table?
>
> I.e. A Last Modified property on the records of a table, not on an open
> recordset and not on the Tabledef itself?
>
> Thank you
>
| |
| Joanthan 2005-04-06, 8:06 pm |
| By the way, what i need is a table level property, not a record level property.
I have Front-end forms that on the on_timer event, need to check a back-end
table to see if another user has changed, added or deleted any records. If
yes, then me.requery!
If you have come across a solution in a past post, please give me a link.
Thank you
"Rick B" wrote:
> No. There is no built-in function.
>
> Do a search for "timestamp" and you will find many many previous posts that
> address methods to do this.
>
> You should always search before posting a new thread. 9 times out of 10 you
> will find your answer.
>
> Rick B
>
>
> "Joanthan" < Joanthan@discussions
.microsoft.com> wrote in message
> news:2C5E0EE1-17F9-4E6A-BD14- C50399522F71@microso
ft.com...
> of
>
>
>
| |
| Douglas J. Steele 2005-04-06, 8:06 pm |
| If you maintain timestamps on each record, you can do a query to return any
records with a timestamp greater than the last time you ran the query. If
any records come back, you know something's been changed.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Joanthan" < Joanthan@discussions
.microsoft.com> wrote in message
news:B2E9FC03-2F66-41E4-B8D8- 4E4900C827D7@microso
ft.com...[color=darkred]
> By the way, what i need is a table level property, not a record level
> property.
>
> I have Front-end forms that on the on_timer event, need to check a
> back-end
> table to see if another user has changed, added or deleted any records. If
> yes, then me.requery!
>
> If you have come across a solution in a past post, please give me a link.
>
> Thank you
>
>
>
>
> "Rick B" wrote:
>
| |
| Joanthan 2005-04-06, 8:06 pm |
| Thank you for your input.
What this means is I will have to run a DMax()
on the timestamp field and a DCount() on the
primary key field, to catch Edited records,
New records and Deleted records.
Running the above every few seconds on the
on_timer event is going to be pretty heavy on
the network, especially since we are talking about
large tables.
I suppose the next best solution would be to trap Edits,
Additions and Deletions on the Form and store the
timestamp in either a custom property on the table,
or create another table especially for this purpose,
and store it there.
I imagine the extra table will be fastest solution.
If you know of anything better please let me know.
|
|
|
|
|