troubleshooting Question

How can i identify what data has changed on an Access 2003 form

Avatar of JulesII
JulesII asked on
Visual Basic ClassicMicrosoft DevelopmentMicrosoft Access
7 Comments2 Solutions382 ViewsLast Modified:
Hi,
I'm a bit stuck on this issue and wonder if you could help?  we have field workers who do not have access to the companies Servers and need to be able to download data from the live SQL Server datbases and work with the data offline on their tablets and then update the live database again at the end of the day.  If is not possible for them to be logged on at all times due to issues with site locations etc.  I would like to be able to trap any records that get changed during the day, probably on only a handful of specific tables and then to be able to run an update query to push the data back into the live system when they log back on.  I'm imagining something that would know when a form has been updated and which field in an underlying table has been changed.  I think I would then record that change to a table which would hold the name of the table and field to update along with the value to change.  I'm stuck on knowing how to identify the control that has been updated.
Any help as always would be very much appreciated
ASKER CERTIFIED SOLUTION
omgang
IT Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros