How to combine (ADD specifically) two STRUCTURALLY IDENTICAL access db's
Posted on 2012-09-16
I have a coldfusion / access db which runs on a standalone pc platform. It is used for registration of students. It has been used for several years with no problems. I would now like to run TWO instances of the application on two seperate PC's to quicken the registration process.
So, I would like, at the end of each day to run a routine which would combine the databases as above into a new database. The updated database would be used in both machines the following day.
Clearly each of the databases are identical - EXCEPT - one database may have some extra fields to accomodate new students.
Would appreciate confirmation of the feasibility of trying this and an approach to creating the coldfusion script