By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,605 Members | 1,329 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,605 IT Pros & Developers. It's quick & easy.

Announcing Data Swap for MS Access

P: n/a
Please excuse this blatant attempt at advertising. I hope you find this
software both interesting and useful.

http://www.caddproductivity.com/dataswap.htm

Data Swap

The Data Swap program works with Microsoft® Access databases to make
complex queries or repetitive tasks simple.

Data Swap works with one or two databases at time. Where a function
interacts with two databases at once the notation ‘2nd’ appears in the
function’s title. Other functions, such as ‘Find and Replace’, work with
the 1st or 2nd (optional) selected database.

Major Functions:

* Find and Replace
* Copy Table(s) to 1st/2nd MDB
* Back-Up Selected Tables
* Clear Selected Tables
* Update 2nd from 1st MDB
* Compare 1st and 2nd Tables
Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
msg
What is the advantage of Data Swap over just Sychronizing your database?

Nov 13 '05 #2

P: n/a
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.
Nov 13 '05 #3

P: n/a
ma**@caddproductivity.com wrote:
msg wrote:
What is the advantage of Data Swap over just Sychronizing your
database?


Data Swap has 6 distinct tools.


And you think spamming groups where advertising is explicitly prohibited by the
charter will win you loads of loyal customers?

DLTDHYITAOYWO

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #4

P: n/a

"Rick Brandt" <ri*********@hotmail.com> schreef in bericht news:rP******************@newssvr25.news.prodigy.n et...
DLTDHYITAOYWO


??? I am Dutch ... Can anyone translate this ?
I did not find it at acronymfinder ... ;-)

Arno R
Nov 13 '05 #5

P: n/a
On Thu, 3 Nov 2005 09:11:15 +0100, "Arno R" <ar***********@tiscali.nl> wrote:

"Rick Brandt" <ri*********@hotmail.com> schreef in bericht news:rP******************@newssvr25.news.prodigy.n et...
DLTDHYITAOYWO


??? I am Dutch ... Can anyone translate this ?
I did not find it at acronymfinder ... ;-)


Don't let the door hit you in the ass on your way out!

Nov 13 '05 #6

P: n/a

"Wayne Gillespie" <be*****@NOhotmailSPAM.com.au> schreef in bericht news:f8********************************@4ax.com...
On Thu, 3 Nov 2005 09:11:15 +0100, "Arno R" <ar***********@tiscali.nl> wrote:

"Rick Brandt" <ri*********@hotmail.com> schreef in bericht news:rP******************@newssvr25.news.prodigy.n et...
DLTDHYITAOYWO


??? I am Dutch ... Can anyone translate this ?
I did not find it at acronymfinder ... ;-)


Don't let the door hit you in the ass on your way out!


OK Thanks.
GIWIST ;-)

Arno R
Nov 13 '05 #7

P: n/a
<ma**@xxxxxxxxxxxxxxxx.com> wrote
Please excuse this blatant attempt at advertising.


Steve? Izzat you? No? In that case, please see the FAQ at
http://www.mvps.org/access/netiquette.htm for the official view on
advertising in comp.databases.ms-access. Thank you for complying with the
charter in the future.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.