Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Kev InAz
  Where is Kev InAz?
 
 Arizona - United States
 Kev InAz
 Tags
Subject: Tracking Record Changes In a Table.
Thread ID: 33795 Message ID: 33795 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Wednesday, December 03, 2003 6:53:52 PM         
   



I have a client who has an inventory system I created that does record the user name and time of any transaction.

The problem is a bunch of records were changed in their inventory and all the user and time fields are blank. Another problem is that some of the owners use VFP.exe to view a table directly and sometimes make changes.

Now the main owner wants to know why all those records got changed.

I know in a database container you can have a program run every time the table is accessed. But all the tables in this application are not in database containers. So my question is, is there a way to have a program run every time someone accesses a table that is not in a database container. Even if it's opened in VFP.exe?

ENTIRE THREAD

Tracking Record Changes In a Table. Posted by Kev InAz @ 12/3/2003 6:53:52 PM
RE: Tracking Record Changes In a Table. Posted by Jamie Osborn @ 12/3/2003 11:41:25 PM