msg wrote:
What is the advantage of Data Swap over just Sychronizing your database?
Data Swap has 6 distinct tools.
Concerning the 'Update 2nd from 1st MDB' tool as compared to
synchronization :
Update allows you to specify (query for)which records will be updated in
one table by another (between separate databases). In other words, all
records need not be updated, only records satisfying the (selected)
query criteria.
While this may be possible via vanilla Access, Data Swap attempts to
make this task relatively simple (including a preview of the SQL before
execution). While I'm very new to this NG it appears there is a certain
level of expertise which is uncommon among the average Access user. That
is to say, the average office Joe, faced with updating one database with
another, while leaving other records unaffected, may find Data Swap a
useful tool (with a reasonably friendly GUI).
I appreciate all comments and insights (really) as I'm just now bringing
this product to market.
Data Swap, by the way, is free to download, fully functional for thirty
days.
Regards,
Mark
The following is from
http://www.caddproductivity.com/dataswapimage.htm
The Update function works by matching records (via specified field
values to match). When a record (or records) is matched between tables
in the 1st and 2nd MDB, the selected field values to 'Update' are
written to the 2nd table from the 1st table. This function is especially
useful when one table requires a specific data-set update from another
(while not affecting uninvolved field values in the same record set).
To perform the Update function both databases must contain the same
table name. Fields eligible for Update in the 2nd MDB's table must have
the same name and data type as their counterparts in the 1st MDB. Note
that when matching fields data types differ, the particular fields may
not be used, however other fields may still be eligible for Update.
To specify the which Fields in the selected Table to Update:
First select the fields to match values between tables. In the
'Update/Match' column, key the 'm' key to specify fields whose values
must be matched between tables to qualify an Update. Second select the
fields to Update. In the 'Update/Match' column, key the 'u' key to
specify fields whose values will be Updated. In either case, key any key
other than 'm' or 'u' to clear existing 'Match' or 'Update' entries.
The 'Preview SQL' checkbox is checked by default. When checked a message
box will appear (after clicking 'Go') showing the specified Match/Update
criteria. Click Yes to continue with the Update.
To execute to the Update: Press to 'Go' button. A vertical progress bar,
at the right of the form, indicates the Update's progress.
