Do I have to combine 2 database into 1?

[itlearner]

My application links to 3 mdb (eg. 1a.mdb, 2b.mdb, 3c.mdb) backend database.

It works as the following: if an order is placed by a company (public sale), the order will be stored in 1a.mdb, if the order is for private sale, the order will be stored in 2b.mdb. The items for public sale are stored in 1a.mdb, the items for private sale are stored in 2b.mdb. It means an order cannot combine both public and private sales, but in fact this always an issue. 3c.mdb is used for storing common data, such as customer details.

Now I would like to create an order that includes both public and private sales. How I can do that? Do I have to combine 1a.mdb and 2b.mdb into 1 database?

Any suggestion is welcome.

 

[Banana]

Maybe. Maybe not.

Read up on ADP (Access Data Project) which can handle multiple database and see if this fits your needs.

 

[neileg]

I would say that not only should the data be in a single database, it should be in a single table with a field to indicate public or private.