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

From: Scotter (spam_at_spam.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 22:04:26 GMT

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:uNNKjfboEHA.132@TK2MSFTNGP14.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" <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...
>>> 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).
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Relevant Pages

  • ms-access 2007 online? How can users log on to access 2007 from the internet?
    ... with SQL Server Express running on ... FTP to the Access database that is now online. ... What software do I need and how can i put it online? ... Also, Microsoft has a free upgrade, downloadable from their web site, ...
    (comp.databases.ms-access)
  • Re: Prolog on a web server
    ... thrilled if you wanted to load it all into server VM:-/ ... rapidly build yourself a desktop app (Delphi? ... As for Prolog, it could surely be the basis of a decent ... grown-up database query language (an open standard dialect ...
    (comp.lang.prolog)
  • Re: Python Database Apps
    ... It's gonna be a desktop app. ... so that I don't need a database server on the client side. ... If you have an offline mode then the most important thing to work out ...
    (comp.lang.python)
  • Re: HELP PLEASE - need app to modify multiple MDB table designs simultaneously
    ... ONE database runs ONE application and EACH ... application runs only ONE web site and it work great this way. ... particular app, it would not be efficient to have ONE application run ALL ... web sites on my server. ...
    (microsoft.public.inetserver.asp.general)
  • Re: HELP PLEASE - need app to modify multiple MDB table designs simultaneously
    ... ONE database runs ONE application and EACH ... application runs only ONE web site and it work great this way. ... particular app, it would not be efficient to have ONE application run ALL ... web sites on my server. ...
    (microsoft.public.dotnet.general)