Using Access97 several departments were given information to key-in to process a key component of our work. Consolidation is now the order of the day and I'm faced with joining the database and giving the task to one person. The problem is that the database has the same name for all of the components. Keeping the same structure is very important as well as not loosing any data. Is there a way to join the database tables with some sort of append?