Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old November 19th, 2003, 03:46 PM
OCM OCM is offline
Registered User
Join Date: Nov 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Combining records


I have a situation where two users have the exact same copy of the same database. When they are out on the field, one user enters in the SiteID field starting 1000 and the other user enters in the SiteID field starting 2000 in AppData table.
They eventually want to get a server and put the back end (table) on a server and the front end in their machines. But my goal for now is when they come to the office to be able to combine both (SiteID) in one database.

Any help would be greatly appreciated!

Old November 19th, 2003, 04:40 PM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

Create one database out of the two and do replication. You may keep the master and they can syncronize when they are in the office.
Is SiteID an autonumber field? if it is I think that replication does not allow them.

Old November 19th, 2003, 04:51 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts

Autonumbers are allowed, but they will be set to random rather than incrementing.

A better choice would be to use a GUID (replication ID?) as the key field.

Brian Skelton
Braxis Computer Services Ltd.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining PHP and C++ Waffles C++ Programming 0 August 3rd, 2007 01:20 PM
Combining two Queries arholly Access 1 January 16th, 2007 06:40 PM
Combining Records in a Report monitor Access VBA 1 April 14th, 2004 07:02 PM
Combining tables spraveens Access 2 December 29th, 2003 11:08 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.