B
Benjamins via AccessMonster.com
Hi,
I have 2 database call db1.mdb and db2.mdb.
db1 is the database that contains data which user is currently.
db2 is the latest database format where there is no data and only I have it.
Currently we have many different db1 with different version and my company
wish to standardize the database. It will be difficult for me to go to the
different db1 to update the database format.
What i did send a update together with db2 to the users to update the system.
This will allow the system to compare the db1 with db2. If the system find
any mismatch, it will do the following remedies:
1) Insert the new table with the fields if table is not found in db1
2) Insert the new field if field is not found in db1 table
3) Change the field Attributes,DefaultValue,etc if different
There is no issue for the 1st issue as i will just import the table. For the
2nd and 3rd issue, how do i compare and update the field so that the fields
will be exactly the same as what is in db2
I have 2 database call db1.mdb and db2.mdb.
db1 is the database that contains data which user is currently.
db2 is the latest database format where there is no data and only I have it.
Currently we have many different db1 with different version and my company
wish to standardize the database. It will be difficult for me to go to the
different db1 to update the database format.
What i did send a update together with db2 to the users to update the system.
This will allow the system to compare the db1 with db2. If the system find
any mismatch, it will do the following remedies:
1) Insert the new table with the fields if table is not found in db1
2) Insert the new field if field is not found in db1 table
3) Change the field Attributes,DefaultValue,etc if different
There is no issue for the 1st issue as i will just import the table. For the
2nd and 3rd issue, how do i compare and update the field so that the fields
will be exactly the same as what is in db2