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 June 16th, 2003, 01:34 PM
Authorized User
Join Date: Jun 2003
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to kev_79
Default compiling data

Is there a way to compile data from 2 or more .mdb's into 1. For instance, if a small database was created and then copied and the same db used by 2 different people. When they are done compiling data, can you make these two file into one since they are the exact same except for data. Thanks in advance.

Old June 16th, 2003, 07:35 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts

I'm sure there's many different ways you could do it using JRO,ADO,DAO or any number of other kinds of fancy methods - but the easiest way would be to just use append queries to append the data from one file to the other

There are 10 kinds of people in the world - those who understand binary - and those with friends

Similar Threads
Thread Thread Starter Forum Replies Last Post
help with compiling mastrgamr C++ Programming 5 November 13th, 2006 08:04 AM
Compiling MattLeek C# 6 April 30th, 2006 04:57 PM
problem with compiling centy Visual C++ 4 February 8th, 2005 02:27 AM
Compiling Zweiglumen C# 0 February 3rd, 2005 10:38 AM
Compiling my first namespace westmich Pro VB.NET 2002/2003 1 September 8th, 2003 11:49 AM

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