I really wish you all would stop second guessing how/why I built the
application as I did and just tell me of software that does what I need if
you know if it existing. If you can't contribute then please don't badger me
with advice about an application you have no idea about.
PLEASE trust I had good reason to build the app the way I did and that for
this particular application, ONE database runs ONE application and EACH
application runs only ONE web site and it work great this way. For this
particular app, it would not be efficient to have ONE application run ALL
web sites on my server (and all the other servers running this app).
In case you didn't read my explanation earlier, here it is:
I have written a web content managment system that uses an MDB as it's
back-end.
I happen to be running twenty (and more each day) very similar versions of
this *application* on my 2003 Server.
Each *application* (with it's MDB) has very different data but same table
structure.
So each *application* has an identical structure but different data; for the
most part. Some few have departed from the exact same schema.
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:uN******** *****@TK2MSFTNG P14.phx.gbl...
His question is not irrelevant at all. I'm going to guess that you have
some setup where each user has his own database. If it's something like
that, you aren't making good use of databases in general. Instead of
finding a solution to doing something the wrong way in a faster way,
people here are trying to offer suggestions of doing things the right way
which would then negate the need for jumping through hoops!
Ray at work
"Scotter" <sp**@spam.co m> wrote in message
news:jv******** **********@fe2. texas.rr.com... Trust me your question is irrelevant to what I need help finding.
If you are really curious, though, see my answer at
microsoft.publi c.access.3rdpar tyusrgrp.
I'm not sure of exact protocol for the cross-posting I'm doing and I
don't want to piss people off.
Thanks!
"Steven Burn" <pv*@noyb.com > wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. .. But _WHY_ do you need 20 database's?
--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
"Scotter" <sp**@spam.co m> wrote in message
news:m7******** *********@fe2.t exas.rr.com...
They do not have identical data in them.
Only their *structure* is identical.
So... when I come up with an upgrade, I would rather not open up 20
different databases one at a time to change/add field(s)/table(s).