troubleshooting Question

Access database copy

Avatar of Chris Bottomley
Chris BottomleyFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft OfficeMicrosoft AccessMicrosoft Applications
20 Comments2 Solutions383 ViewsLast Modified:
I am about to embark on taking an existing database and adapting it.  Since the data is sensitive I would like to create a dummy for use here but be able to lift the real data from the original file into the public file for testing.

This question therefore is as follows:

If I have a db of several fields and want to upload data from different db, assume same data structures for now can you define a simple, ( to edit) way that db1 fields string1a int2a and date3a can all be copied across to db2 where the fields are string1b int2b and date3b.  The mapping between db fields may be completely unrelated so do not assume a naming convention ... This is so the db application can also be hidden!

Needs to be compatible with access 2003 through 2010 to permit different people to use and work with the db.

Chris
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 20 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 20 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros