HELP PLEASE - need app to modify multiple MDB table designs simultaneously

Okay I think my title line was worded misleadingly. So here goes again.

I've got quite 20 identical MDB files running on an IIS5 server.
From time to time I need to go into various tables and add a field or two.
It would be great if there were an application out there that could either:
(a) sync all MDB designs (and/or data) designated to match one I've added
some fields/tables to
OR
(b) go into all designated MDBs and create new field(s) or table(s).

I've began writing something like this that right now just does part of (b)
but I'd rather find something that is much more slick and complete.
--
Scotter

Is there a reason why you have to have 20 identical MDBs? Can you not
combine everything into one?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Scotter" <spam@spam.com> wrote in message
news:EDG4d.16588$Qb.12964@fe2.texas.rr.com...
> Okay I think my title line was worded misleadingly. So here goes again.
>
> I've got quite 20 identical MDB files running on an IIS5 server.
> From time to time I need to go into various tables and add a field or two.
> It would be great if there were an application out there that could
either:
> (a) sync all MDB designs (and/or data) designated to match one I've added
> some fields/tables to
> OR
> (b) go into all designated MDBs and create new field(s) or table(s).
>
> I've began writing something like this that right now just does part of
(b)
> but I'd rather find something that is much more slick and complete.
> --
> Scotter
>
>

Douglas J. Steele wrote:
> Is there a reason why you have to have 20 identical MDBs? Can you not
> combine everything into one?

...and, if they're truly identical, seems like.... modify one and use
FileCopy to over-write the others.


--
Ken Halter - MS-MVP-VB - http://www.vbsight.com
Please keep all discussions in the groups..

http://aspfaq.com/show.asp?id=2081

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!


"Scotter" <spam@spam.com> wrote in message
news:EDG4d.16588$Qb.12964@fe2.texas.rr.com...
> Okay I think my title line was worded misleadingly. So here goes again.
>
> I've got quite 20 identical MDB files running on an IIS5 server.
> From time to time I need to go into various tables and add a field or two.
> It would be great if there were an application out there that could
either:
> (a) sync all MDB designs (and/or data) designated to match one I've added
> some fields/tables to
> OR
> (b) go into all designated MDBs and create new field(s) or table(s).
>
> I've began writing something like this that right now just does part of
(b)
> but I'd rather find something that is much more slick and complete.
> --
> Scotter
>
>

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).

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" <spam@spam.com> wrote in message
news:m7H4d.16609$Qb.8292@fe2.texas.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).
>
>

Trust me your question is irrelevant to what I need help finding.
If you are really curious, though, see my answer at
microsoft.public.access.3rdpartyusrgrp.
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" <pvt@noyb.com> wrote in message
news:%23UZj6PboEHA.3520@TK2MSFTNGP11.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" <spam@spam.com> wrote in message
> news:m7H4d.16609$Qb.8292@fe2.texas.rr.com... 
>
>

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" <spam@spam.com> wrote in message
news:jvH4d.16614$Qb.10305@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.public.access.3rdpartyusrgrp.
> 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" <pvt@noyb.com> wrote in message
> news:%23UZj6PboEHA.3520@TK2MSFTNGP11.phx.gbl... 
>
>

I see you saying absolutely no need for 20 databases and I'm wondeirng if
maybe you  my description of my situation to be that I'm running 20
databases PER application?
If that were the case then yeah maybe but please re-read to find that I am
running ONE database PER ONE application.

"Steven Burn" <pvt@noyb.com> wrote in message
news:%239dEplboEHA.2032@TK2MSFTNGP10.phx.gbl...
> "Scotter" <spam@spam.com> wrote in message
> news:jvH4d.16614$Qb.10305@fe2.texas.rr.com... 
>
> It's not irrelevant at all...... there's absolutely no need to have 20
> database's.... (20 _tables_ in ONE database maybe (and even then, this
> shouldn't be necessary), but definately not 20 database's)
> 
>
> I don't visit that NG ;o)
> 
>
> See the link Ray posted......
>
> http://aspfaq.com/5004
>
> --
>
> Regards
>
> Steven Burn
> Ur I.T. Mate Group
> www.it-mate.co.uk
>
> Keeping it FREE!
>
>
>

"Scotter" <spam@spam.com> wrote in message
news:KLH4d.16618$Qb.1733@fe2.texas.rr.com...
> 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.
</snip>

Now this type of attitude isn't gonna get you anywhere....

As far as badgering you about an application we have no idea about....
perhaps if you explained it to us, we'd have an idea.

I don't mean to offend but, the guys that volunteer here, know what they are
talking about, and "badger you with advice", in an effort to get you to do
things the _right_ way, which will in turn, make _YOUR_ job a heck of alot
easier.

If however, you don't want advice, then you should really make sure you put
something along the lines of ....

"I don't give a rats right bollock about what you think of the way I am
doing things, so would appreciate your not trying to tell me how I should be
doing this, and just answer my question instead"

.... in your first post.

> 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.

But thats the point!. If you are going to be using database's, you really
_should_ learn to use them effectively, and correctly, rather than what may
_look_ easier.

> 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).

Then you should really re-think the way you designed it.

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!