Merging databases

[Marvic]

Sorry if this is in the wrong place - I am very new to this site

I am using Acess 2000 and I am not that brilliant at it

Is there any way to merge two of the sample databases which comes with
Access together - I would like to have the Inventory Control and the Order
Entry databases as one database - can this be done? There is no data in the
databases yet

Hope someone can help and thanks for looking

 

[Jeff Boyce]

Marvic

That really depends on what you mean by "merging two databases".

Just like Word or Excel, you could just copy what's in one into another.

Unlike Word or Excel, you typically would also be looking to "copy" the
application (the part the user uses), not just the data/tables.

While you can copy the forms and queries and reports (and tables, and code
and ...) from one Access database (.mdb file) into another, making them work
together is YOUR job!

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Marvic]

That is what I have found!

I have imported everything into one database quite easily (not sure if that
was the right way to do it) but to get them to work together not so! Not
really sure what I need to do

Any ideas

 

[Pete D.]

Have you looked at the sample file Northwinds trader, might give you some
ideas. It combines an inventory with order entry.

 

[Jeff Boyce]

Marvic

It sounds like you are asking how to do the work to develop a "complete"
application, combining a couple different pieces. These newsgroups work
great for getting answers to specific questions, but yours seems to be more
a "how do I build an application" question. The volunteers here are unlike
to respond to a more general request.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/