Append Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a database that is designed as FE/BE. There are two users and each
one has thier BE in their own folder which resides on the same server.How do
i go about merging the two BE so the data from both users can be in one BE?
The BE from both users have the same fields and only three tables which are
the same as well, and the BE for both users have the same name like Acct
data_be.mdb.Please advise..thanks
 
Hi,

I have a database that is designed as FE/BE. There are two users and each
one has thier BE in their own folder which resides on the same server.How do
i go about merging the two BE so the data from both users can be in one BE?
The BE from both users have the same fields and only three tables which are
the same as well, and the BE for both users have the same name like Acct
data_be.mdb.Please advise..thanks
Click to expand...

The problem is going to be data conflicts between the two databases.
For instance, if any of the tables have Autonumber primary keys, there
are almost certainly records with the same autonumber value but
DIFFERENT data in the two users' tables. This will be especially
problematic if there are foreign key values linked to these
autonumbers.

In addition, what happens if both users have legitimately entered data
for the same account, or for the same customer - and the data is
(slightly or completely) different? How do you intend to resolve
conflicts?

I've been there, done that, and had to throw the T-shirt in the rag
drawer after I got done... NOT fun! You might be luckier, but you do
need to resolve these quesetions first!

John W. Vinson[MVP]
 
OK,

How about if i want to add additional data on top of the other? For
instance given the same information in this post, Lets say one BE has
transactions that ended on 01/01/2006 and the other BE has transactions from
01/02/2006 until 03/10/2006. Does your answer still apply or can you add-on
as described above so at least one BE is current with data added from
01/02/2006 untill today's date?
Thanks
 
OK,

How about if i want to add additional data on top of the other? For
instance given the same information in this post, Lets say one BE has
transactions that ended on 01/01/2006 and the other BE has transactions from
01/02/2006 until 03/10/2006. Does your answer still apply or can you add-on
as described above so at least one BE is current with data added from
01/02/2006 untill today's date?
Click to expand...

Bear in mind I have NO idea how your tables are structured or how
these date ranges are stored - but I think you just made a difficult
problem even more difficult.

You can use an Append query on a linked table (File... Get External
Data... Link) to *add* records from one backend database into the
corresponding table in another backend database. That's not the issue.
The problem is whether those added records conflict with existing
records, duplicate existing records, or make no sense in the context
of existing records. Since I don't know anything about your database
or your data, I cannot answer those questions - but I can raise them.


John W. Vinson[MVP]
 
sir i want to know what i need to submit in design and analysis part of my
project
 
sir i want to know what i need to submit in design and analysis part of my
project
Click to expand...

I'm sorry, I have no idea WHAT you're talking about.

I'm not your professor. I didn't assign your project. And your
question appears to have nothing whatsoever to do with this thread.

John W. Vinson[MVP]
 
Back
Top