Have an question, hope it makes sense.

Unfortunatly I didn't write the program my company uses, but I'll try my
best to explain.

We load vehicle information into the program, the program creates an
inventory.mdb when we upload it to our server. The program also uploads
3 asp pages, an include file (I'm assuming that is what the .inc is)
The information from the database is loaded into the needed areas of the
ASP file.

Now, we do this with multiple dealerships. Around 11 of them. Each has
its own place on our server, and its own inventory.mdb.

What I'm trying to do, is find a way of either merging all the databases
so that we can have a central inventory list of all the vehicles all
our lots have,
or if we can, just create an ASP page that includes all the info from
all the remote db's.

An example of our inventory page is
http://ws06.ipowerweb.com/maconsal/y.../Inventory.asp

Is any of this possible?

Thanks in advance

Sean Summers

Makonga Inc.

There are many ways to deal with this.
I'm going to outline the simplest.
Create an empty DB.
Copy one of the Inventory tables from one of the existing dbs.
Rename it to "Master" and delete the contents.
Now link each of the 11 Inventory files to the new db.
Since they probably all have the same name, when you are done you will
have 11 linked tables named:
INV,INV1,INV2,INV3....

Now you need 11 append queries to append the linked tables to Master.

An ASP page based on Master will give you what you want.

You may need to add a location field to the INV tables if they don't
have one.

You will need to write one macro .

You would run the macro once a day, either just before opening or
after all the updates are in after closing.

Note that Master is just for lookups. In this scheme changes to
Master will not reflect in the individual dbs. If you want that we
need to do it in a different way.

Good luck

Ira Solomon

On Tue, 19 Oct 2004 20:40:10 -0400, sean <s.summers (AT) cox (DOT) net> wrote: