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

Network Update Data,Information needed

P: n/a
DD
I have not networked a computer before so here is my situation,,if
someone can guide me to the right procedure and information.

x2 shops (shopA) (shopB)

Both are using a laptop, each with the same data as the other,, shopA
want to at the end of each month import all the new data from shopB
into shopA laptop

The data includes CustomerDetails and CustomerPurchaseDetails..

Can someone offer the direction i should go

DD
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
In message <14**************************@posting.google.com >, DD
<da**********@bigpond.com.au> writes
I have not networked a computer before so here is my situation,,if
someone can guide me to the right procedure and information.

x2 shops (shopA) (shopB)

Both are using a laptop, each with the same data as the other,, shopA
want to at the end of each month import all the new data from shopB
into shopA laptop

The data includes CustomerDetails and CustomerPurchaseDetails..

Can someone offer the direction i should go


This is what I would do, but I don't know how your data is structured.

In general its a good idea to keep the forms etc in one database and
just the data in a separate file. The front-end database with the forms
has links to the file with the data in it.

In the front-end database for Shop A create additional links pointing to
a copy of the data file for shop B in addition to the links to the data
file from shop A.

Create append queries that merge the table from shop A with the matching
table from shop B. You could choose to merge only the records for the
last month but that involves adding a selection process and that could
introduce errors.

What you do need to look out for is situations where the same customer
appears in both databases. You may choose to ignore that situation, or
you may want to remove the duplicates. The code to do that will be
non-trivial and probably more complex than I would try to explain here.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.