>I am writing a client server application that requires the use of 16 lookup tables that I would like to store locally on each users workstation or on a shared network drive. These lookup tables are fairly static an occupy less than a meg with index files. What is the best way to compare these local tables with the equivalent tables in an Oracle database. The intent is to only refresh the local individual table when the Oracle table has been updated. I would want to check if the tables have changed each time the user starts the application. Any suggestions would be greatly appreciated.
>
>Thanks,
>
>Greg
>
>P.S. Using VFP 6.0 SP3 and Oracle 7.3.3

If they are that small, you should be able to update them at program startup. You could recreate them every time your program starts.

Wayne