Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
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 September 27th, 2005, 07:01 AM
Friend of Wrox
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default Pasting information to a second database

I have two databases that sit in two different locations.Two of the fields in each database have the same information contained in them.One of the databases has the information on these two fields updated.I now need to be able to copy this information in these fields and paste it into the second database.Nothing else in either database is Similar.

Brendan Bartley
Brendan Bartley
Old September 27th, 2005, 09:45 AM
Friend of Wrox
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts

Hi Brendan,

Just for some clarification...

Is it just one field that needs to be transferred over, or could it be whole table. It it is a whole table, you may want to consider having one database hold the table, and then creating a link to that table from the other database.

If it is just one field, are there any other fields in the tables that match and could be used as a reference when updating the field in question?

Let us know, there are probably a whole handful of people on this forum that could help you out.



Similar Threads
Thread Thread Starter Forum Replies Last Post
saving table of information back into database mrjits Excel VBA 3 July 17th, 2006 01:42 PM
Connecting login to more database information donthomaso Dreamweaver (all versions) 3 May 9th, 2005 03:28 PM
Urgent:Need help to INSERT information to database huat81 C# 4 January 14th, 2005 06:06 AM
Failed to load database information r_ganesh76 Crystal Reports 4 October 7th, 2004 03:04 AM
Internet Database System Information pshan33 MySQL 4 October 6th, 2003 12:18 PM

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