Comparing tables form 2 different database

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200905/1

.

Relevant Pages

  • Re: screwed non-us7ascii characters while selecting from a database link
    ... db1: ... db2 on SUSE SLES9. ... CREATE DATABASE LINK db1_link CONNECT TO user IDENTIFIED BY password ... from db1 and imp them into db2 the characters are converted correcly. ...
    (comp.databases.oracle.server)
  • SQL DB to MySQL
    ... We have SQL Server 2000 databases residing on one server, ... DB1 contains the main data, ... DB2 contains data about the most recent changes to DB1, The key, table ID, ... Our plan is to schedule a DTS package to update the MySQL database. ...
    (microsoft.public.sqlserver.dts)
  • Query Analyzer Default Database
    ... You have to set 'DB2' as ... all the ODBC connections ... Database To" option in the ODBC settings, to DB1. ...
    (microsoft.public.sqlserver.server)
  • Re: screwed non-us7ascii characters while selecting from a database link
    ... db1: ... db2 on SUSE SLES9. ... CREATE DATABASE LINK db1_link CONNECT TO user IDENTIFIED BY password ... The problem is probably that db2, when acting as client to of, has ...
    (comp.databases.oracle.server)
  • Re: import & export data on form
    ... it you want to transer A thru E from database 1 to database 2 and then enter ... fields A thru E are bound to db1 and this information will be ... Lines, 2 Consumer Cards, 4 Business accounts associated under one social ... My quality review is supposed to gather all account ...
    (microsoft.public.access.forms)