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.