Determine which records have been modified before synchronization "rg" <rg01[ at ]goodnews.net> 03.08.2006 22:14:53 I have inherited a database that was converted to use replication. The original database was split into a UI database (forms, reports only) and a database containing data (replica). The UI links to a replica on users workstations. The system works well and replication has been a great success. We do not want to modify the existing UI (forms) because all works well. How can I accomplish the following - when a user has made changes to table data, via the original forms in the UI, and without changing the forms in the UI, I would like to determine which records have been modified before the user synchronizes, in order to log information and store that information in a different table. Synchronization is handled via VBA code so there is an opportunity to look at records in the table to determine which records have been changed. Can I determine this by looking at the additional fields Access adds to a table, once a synchronization has been completed? Thank you.

Re: Determine which records have been modified before synchronization "David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> 03.08.2006 23:18:29 "rg" <rg01[ at ]goodnews.net> wrote in news:euKFAp0tGHA.4456[ at ]TK2MSFTNGP06.phx.gbl: [Quoted Text] > How can I accomplish the following - when a user has made changes > to table data, via the original forms in the UI, and without > changing the forms in the UI, I would like to determine which > records have been modified before the user synchronizes, in order > to log information and store that information in a different > table. > > Synchronization is handled via VBA code so there is an opportunity > to look at records in the table to determine which records have > been changed. Can I determine this by looking at the > additional fields Access adds to a table, once a synchronization > has been completed? Sounds like an awful lot of work, and I'm not certain that the information you need is there. All there is are generations -- that won't tell you *what* the changes are. You might want to look at: http://allenbrowne.com/AppAudit.html which shows you how to change your editing forms to keep an audit trail. Of course, it may be simple enough to just stamp all the records with a date and user each time they are changed. Then you could tell which records that particular user has changed since the last synch (which you'd need to record or look up from the back end's history table). -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/

Re: Determine which records have been modified before synchronization jacksonmacd <jackMACmacdo0nald[ at ]telus.net> 04.08.2006 01:50:48 On Thu, 3 Aug 2006 18:14:53 -0400, "rg" <rg01[ at ]goodnews.net> wrote: [Quoted Text] >I have inherited a database that was converted to use replication. The >original database was split into a UI database (forms, reports only) and a >database containing data (replica). The UI links to a replica on users >workstations. > >The system works well and replication has been a great success. We do not >want to modify the existing UI (forms) because all works well. > >How can I accomplish the following - when a user has made changes to table >data, via the original forms in the UI, and without changing the forms in >the UI, I would like to determine which records have been modified before >the user synchronizes, in order to log information and store that >information in a different table. > >Synchronization is handled via VBA code so there is an opportunity to look >at records in the table to determine which records have been changed. Can >I determine this by looking at the additional fields Access adds to a >table, once a synchronization has been completed? > >Thank you. > If I recall correctly, the s_Generation field (hidden) in each replicated table will have a non-zero value if it has been changed, and a zero value if it's been synchronized with another replica. I've never used it -- just poked around enough to pique my curiosity. You could probably use this field to determine which records are about to be synchronized. Use the Tools > Options menu item to reveal the various hidden objects in your database. Proceed cautiously!!! -- jackmacMACdonald[ at ]telusTELUS.net remove uppercase letters for true email http://www.geocities.com/jacksonmacd/ for info on MS Access security