Syncronize or merge

[shampoo]

Me and my college work on same Access database filling data in, but we work
separate, "decentralized type".

Can we somehow merge or synchronize our tables when we finish, we have no
different fields in our db.

Thanx

 

[Douglas J Steele]

You could take a look at Access Replication (do a search at
http://search.microsoft.com/search/search.aspx?st=a&View=en-us)

Note: for Replication to work effectively, you need to split your
application into a front-end (containing the queries, forms, reports, macros
and modules), linked to a back-end (containing the tables). Only the
back-end should be replicated.

 

[Larry Daugherty]

Maybe.

Assuming one or the other of you designed your application, that you
even ask the question is a pretty good indicator that you can.

If you have tables related to other tables in a one-to-many
relationship and the "main" tables use autonumbers for primary keys
you may have a problem. Most other situations are easily resolvable.
To get definitive answers, even the steps to a solution, you'd have to
post back with a description and the details of your data design.

HTH

 

[shampoo]

Its simple database, with only one table (so there is no relations) and 8
fields (text,and one Date/Time, there is no "ID AutoNumber").

In recent future we only plan to make som queries for the reports and thats
it.

I would appreciate if someone colud provide me with stepbystep creating
replica, i tried myself and i cant make sync. it prompts me error like
"different replica set".

 

[Larry Daugherty]

You don't need to fiddle with replication for what you have.


You decide whose set is A and whose is B. Just keep the assignment
straight through the complete iteration Work with copies of your data
until you're sure you have it right.
..

To synchronize:

Get copies of the two databases into a single folder on the machine
where the concatenation will be performed with the letter A prefixed
to one and the letter B prefixed to the other.

In A?????.mdb open the Database | Query window and click the New
button. choose Design View. The Query Designer will open with a
window titled Show Table in the center.

Doubleclick your table and click close on that window. Your table
will now appear in the left upper portion of the designer.

Click and drag the asterisk at the top of the table into the Field
window on the grid below. When you release it, the Show box below
will receive a check mark. If it didn't, put a check mark there.

On the menu bar at the top of the window click Query.

Choose Append Query. A window titled Append will open in the center
of the form.

Open the Table Name combobox and click on your table.

Choose the Another Database option. Type in B?????.MDB.

Click OK

=======================================

I'll leave it to you to verify the data in B?????.MDB and to get
copies of it into their proper locations with the proper name(s).
Save your old databases for a while until you know the concatenation
was flawless.

HTH

 

[shampoo]

Dear Larry,
thank you very much this would do it.
But can i through this proces concetration with append query define that
duplicates (exact same data) are removed automaticly.

Thanks agian.

Best regards.

 

[Larry Daugherty]

You'll need to follow the Append query with a Find Duplicates query.

You're welcome.