i have a server program which stores records in a table per year. table 'Record_07' has fields, ID, Time1, Time2, Time3. each table could have about 300,000+ records.
now, i have created a remote program which is on a different computer to generate reports from that database.
i am planning to create a copy of the database on the remote computer so that it can still generate reports offline. i also need the program to automatically update the updated/added records from the server database. i can create a timestamp of my last update time, so i can get the updated records by Where Time1>timestamp or time2>timestamp or time3>timestamp.
how can i do this?
Start Free Trial
