PC Review


Reply
Thread Tools Rate Thread

see records have been updated in a table from an update query

 
 
=?Utf-8?B?YmFicw==?=
Guest
Posts: n/a
 
      1st Nov 2005
Is there anything without adding an extra field - such as date modified (not
it) since doesn't change with update query- where you can see that the
records have been updated with the update query???

thanks,
Barb
 
Reply With Quote
 
 
 
 
=?Utf-8?B?S0FSTCBERVdFWQ==?=
Guest
Posts: n/a
 
      2nd Nov 2005
You could have a Change History table that compares everything on close of
the database and appends a record for everything changed from the last time.

"babs" wrote:

> Is there anything without adding an extra field - such as date modified (not
> it) since doesn't change with update query- where you can see that the
> records have been updated with the update query???
>
> thanks,
> Barb

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
View which messages have been or have not been linked mduijkers@gmail.com Microsoft Outlook BCM 0 6th Jan 2008 08:24 PM
updated system, updated software, so do updated images? smith Windows XP General 1 4th Dec 2007 06:03 PM
How to prevent the form from closing if not ALL of the records have been updated? Morris Microsoft Access Form Coding 3 31st Oct 2006 05:46 PM
have any records been updated or added? Christopher Glaeser Microsoft Access Database Table Design 1 16th May 2005 01:53 AM
Have there been functions in Access 2.0 which have been removed in version XP 2002? Stefan Frank Microsoft Access 2 7th Mar 2005 07:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:30 AM.