Hi,

How do I merge these two datbases? I have downloaded them from Microsoft online templates, here
http://office.microsoft.com/en-gb/templates/TC010178391033.aspx?CategoryID=CT101426031033&av=ZAC000
and here
http://office.microsoft.com/en-gb/templates/TC010185481033.aspx?CategoryID=CT101426031033&av=ZAC000
and I want to have the two databases as one so that there will be a fourth tab on the cintact management database with the order form on? I want to be able to link the two so I can have all the customers details and orders together and print off reports. I really have not dealt with Access before so I really dont have a clue. Any help would be truly appreciated. I am sure it is easy but I just cant work out how to do it.

Thanks very much

Danny :)

I am not an experienced Access Developer, but here is my suggestion

You can create a new database(or use one of them as the main one) and then import all the forms, queries, etc.. from the other database.

Although they are reside in one Access Database, that still doesn't mean that they will work as a single application. If you want to go from DB1 to DB2 (forms), you will still need to create that link.

The other thing to look for is form names, table names, etc... The form(or other objects) may have the same name, but not the same structure.

Hope this give you a start....

EZfriend

This could be a real minefield

lets start
you need copies of the old db (put on a disc to be safe)


now how complicated are these d/b

if they are names addresses and nothing esle then import and append to a new table
you need to figure out what you are going to keep and what gets dumped

This could be a real minefield


Isn't that the truth. The initial request could be compared to a mechanic asking how to take two cars and make them into one. If both are VW Bugs from 1972, then it's easier to do than if one was a '92 Ford Tempo and the other a '88 Porsche.