Read an .mdb file then update to another .mdb file. The original and the updated file will be outside the program. (not imported into the application)
I need a program that can read an access (.mdb) file, which is connected to an OBDC source. Then put all data on the array using simple structure. Once that finish, you need to update it onto another access (.mdb) file. You need to have a procedure to check if the record/file exist, if not, then create new row/file, then update it.
The program needs to have a timer class to update every 15 minutes. Use a button to start and stop timer.
This program will be incorporate into larger project, so, please have neat comments and use subroutines, array, and structures.
A sample of file is included.