Home > Archive > ASP > September 2004 > HELP PLEASE - need app to modify multiple MDB table designs simultaneously
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
HELP PLEASE - need app to modify multiple MDB table designs simultaneously
|
|
| Scotter 2004-09-23, 8:56 pm |
| 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 2004-09-23, 8:56 pm |
| 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
>
>
| |
| Ken Halter 2004-09-23, 8:56 pm |
| 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..
| |
| Steven Burn 2004-09-23, 8:56 pm |
| 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
>
>
| |
| Scotter 2004-09-23, 8:56 pm |
| 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).
| |
| Steven Burn 2004-09-23, 8:56 pm |
| 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).
>
>
| |
| Scotter 2004-09-23, 8:56 pm |
| 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...
>
>
| |
| Ray Costanzo [MVP] 2004-09-23, 8:56 pm |
| 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...
>
>
| |
| Scotter 2004-09-23, 8:56 pm |
| 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...
>
>
| |
| Steven Burn 2004-09-23, 8:56 pm |
| "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.
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)
> If you are really curious, though, see my answer at
> microsoft.public.access.3rdpartyusrgrp.
I don't visit that NG ;o)
> I'm not sure of exact protocol for the cross-posting I'm doing and I don't
> want to piss people off.
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 2004-09-23, 8:56 pm |
| 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!
>
>
>
| |
| Steven Burn 2004-09-23, 8:56 pm |
| "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!
| |
| Steven Burn 2004-09-23, 8:56 pm |
| I read it just fine..... and still don't see why you would need a seperate
database for each application when you could just as easily have one
database, and one table for each application?
--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
"Scotter" <spam@spam.com> wrote in message
news:gUH4d.16621$Qb.1956@fe2.texas.rr.com...
> 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...
>
>
| |
|
| Just let it go!
Some work harder than smarter.
dlbjr
Pleading sagacious indoctrination!
| |
| Scotter 2004-09-23, 8:56 pm |
| hehehee now you are just baiting me, right?
"one table for each application"?
You have no idea what my application does and why it requires about 40
different tables because this is a RELATIONAL database. Maybe you are living
in 1978 where all databases were flat?
Will someone, anyone here who understands that ONE SOLUTION DOES NOT FIT ALL
please step forward and correct these guys and hopefully they will get off
my back.
"Steven Burn" <pvt@noyb.com> wrote in message
news:edhzzsboEHA.3728@TK2MSFTNGP09.phx.gbl...
>I read it just fine..... and still don't see why you would need a seperate
> database for each application when you could just as easily have one
> database, and one table for each application?
>
> --
>
> Regards
>
> Steven Burn
> Ur I.T. Mate Group
> www.it-mate.co.uk
>
> Keeping it FREE!
>
>
> "Scotter" <spam@spam.com> wrote in message
> news:gUH4d.16621$Qb.1956@fe2.texas.rr.com...
> 20
>
>
| |
| Bob Barrows [MVP] 2004-09-23, 8:56 pm |
| Scotter wrote:
> 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
There is. It's called "replication" and it's built into Access.
..
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
| |
| Steven Burn 2004-09-23, 8:56 pm |
| 40 tables per DB?...... if you'd said that when I first asked, I'd have shut
up about the amount of DB's <g>
--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
"Scotter" <spam@spam.com> wrote in message
news:06I4d.16680$Qb.14620@fe2.texas.rr.com...
> hehehee now you are just baiting me, right?
> "one table for each application"?
> You have no idea what my application does and why it requires about 40
> different tables because this is a RELATIONAL database. Maybe you are
living
> in 1978 where all databases were flat?
> Will someone, anyone here who understands that ONE SOLUTION DOES NOT FIT
ALL
> please step forward and correct these guys and hopefully they will get off
> my back.
>
>
> "Steven Burn" <pvt@noyb.com> wrote in message
> news:edhzzsboEHA.3728@TK2MSFTNGP09.phx.gbl...
seperate[color=darkred]
if[color=darkred]
running[color=darkred]
20[color=darkred]
this[color=darkred]
>
>
| |
|
| If the databases are identical for all applications then all applications are capable of running
from one main database.
The key is which data belongs to which application in the database. This can be easily managed. Then
you would be changing just one database. I'm a DBA for Oracle and Microsoft SQLServer systems in a
large environment. So, you can either take advice from people truly trying to help you. Or struggle.
Why do you think not many have struggled to build such a tool you are requesting?
'dlbjr
'Pleading sagacious indoctrination!
| |
| Scotter 2004-09-23, 8:56 pm |
| Yes, I understand why you and the others are recommending I make this
application so it runs multiple web sites instead of just one per MDB.
Tell me something: If you wrote an application to run with an MDB back-end
and you planned on keeping it MS-Access based and this application is a web
CMS, and some of your web clients are big banking institutions and they do
not want their data comingled with other company's data... and some clients
want to have access to their particular MDB... and... and .... and....
would you then put all your eggs in one basket?
Another reason is that these *identical* MDBs sometimes do not stay
identical. I inevitably have clients who want their version of HotKey
customized to run different in some ways and oh boy then it departs from
being like all the others and yeah that presents headaches of it's own but
hey they pay more for support.
Yeah, I realize I could still design each app so it uses one MDB and has
*potential* to host more than one URL. But please please please trust that I
have plenty of other reasons, too, to keep them separate in the case of this
particular application.
If you truly are a pro then you know that there are typically exceptions to
rules.
"dlbjr" <oops@iforgot.com> wrote in message
news:Om$F54boEHA.1460@TK2MSFTNGP12.phx.gbl...
> If the databases are identical for all applications then all applications
> are capable of running
> from one main database.
> The key is which data belongs to which application in the database. This
> can be easily managed. Then
> you would be changing just one database. I'm a DBA for Oracle and
> Microsoft SQLServer systems in a
> large environment. So, you can either take advice from people truly trying
> to help you. Or struggle.
> Why do you think not many have struggled to build such a tool you are
> requesting?
>
>
> 'dlbjr
> 'Pleading sagacious indoctrination!
>
>
| |
| Ray Costanzo [MVP] 2004-09-23, 8:56 pm |
| Send me links to your product. I'm on all the software committees at the
bank where I work. ray@securitynat.com
Ray at work
"Scotter" <spam@spam.com> wrote in message
news:_pI4d.16733$Qb.6786@fe2.texas.rr.com...
> Yes, I understand why you and the others are recommending I make this
> application so it runs multiple web sites instead of just one per MDB.
> Tell me something: If you wrote an application to run with an MDB back-end
> and you planned on keeping it MS-Access based and this application is a
> web CMS, and some of your web clients are big banking institutions and
> they do not want their data comingled with other company's data... and
> some clients want to have access to their particular MDB... and... and
> .... and....
> would you then put all your eggs in one basket?
> Another reason is that these *identical* MDBs sometimes do not stay
> identical. I inevitably have clients who want their version of HotKey
> customized to run different in some ways and oh boy then it departs from
> being like all the others and yeah that presents headaches of it's own but
> hey they pay more for support.
> Yeah, I realize I could still design each app so it uses one MDB and has
> *potential* to host more than one URL. But please please please trust that
> I have plenty of other reasons, too, to keep them separate in the case of
> this particular application.
> If you truly are a pro then you know that there are typically exceptions
> to rules.
>
>
> "dlbjr" <oops@iforgot.com> wrote in message
> news:Om$F54boEHA.1460@TK2MSFTNGP12.phx.gbl...
>
>
| |
|
| If you have banks as clients and you are building these applications for banking systems. I suggest
you get away from Microsoft Access.You may want to look into the Sarbanes-Oxley Act and find that
you must be providing tractability and encryption throughout your web app. Only certain database
solutions can be used for certain data such as banking information.You as the developer will be help
accountable.
Enough said from me.
'dlbjr
'Pleading sagacious indoctrination!
| |
| Scotter 2004-09-23, 8:56 pm |
| not tracking money.
Banking *associations* and other bank-related customers.
If I were hosting an actual BANK, I'd be using SQL Server back end.
"dlbjr" <oops@iforgot.com> wrote in message
news:u7DxcecoEHA.3460@tk2msftngp13.phx.gbl...
> If you have banks as clients and you are building these applications for
> banking systems. I suggest
> you get away from Microsoft Access.You may want to look into the
> Sarbanes-Oxley Act and find that
> you must be providing tractability and encryption throughout your web app.
> Only certain database
> solutions can be used for certain data such as banking information.You as
> the developer will be help
> accountable.
>
> Enough said from me.
>
> 'dlbjr
> 'Pleading sagacious indoctrination!
>
>
| |
| Tony Toews 2004-09-24, 3:55 am |
| "Scotter" <spam@spam.com> wrote:
>Yes, I understand why you and the others are recommending I make this
>application so it runs multiple web sites instead of just one per MDB.
>Tell me something: If you wrote an application to run with an MDB back-end
>and you planned on keeping it MS-Access based and this application is a web
>CMS, and some of your web clients are big banking institutions and they do
>not want their data comingled with other company's data... and some clients
>want to have access to their particular MDB... and... and .... and....
>would you then put all your eggs in one basket?
>Another reason is that these *identical* MDBs sometimes do not stay
>identical. I inevitably have clients who want their version of HotKey
>customized to run different in some ways and oh boy then it departs from
>being like all the others and yeah that presents headaches of it's own but
>hey they pay more for support.
>Yeah, I realize I could still design each app so it uses one MDB and has
>*potential* to host more than one URL. But please please please trust that I
>have plenty of other reasons, too, to keep them separate in the case of this
>particular application.
>If you truly are a pro then you know that there are typically exceptions to
>rules.
Makes sense to me. It can be more work in one way, as you are finding
out but given your situation having separate MDBs makes a lot of
sense.
Also given that Access doesn't handle a large volume of concurrent
updates/inserts, this minimizes the risks of corruptions and reduces
it to just one of the clients at a time.
Do note that "large volume of concurrent updates/inserts" varies
betweens systems, developers and other variables. And differs between
IIS usage vs thick client, ie Access FE MDB/MDE usage.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
| |
| Andrew Zamkovoy 2004-09-24, 3:55 am |
| Hi there,
My telepathic functions are not working properly, but I suppose you want
this:
<%
Dim MyDB, MyUpdates
Redim MyDB (5)
Redim MyUpdates (3)
MyDB (1) = "somewhere/mydb1.mdb"
MyDB (2) = "somewhere/mydb2.mdb"
MyDB (3) = "somewhere/mydb3.mdb"
MyDB (4) = "somewhere/mydb4.mdb"
MyDB (5) = "somewhere/mydb5.mdb"
MyUpdates (1) = "INSERT INTO .........."
MyUpdates (2) = "CREATE TABLE .........."
MyUpdates (3) = "ALTER TABLE .........."
Set goCN = Server.CreateObject("ADODB.Connection")
For I = 1 To 5
goCN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & MyDB (I)
goCN.CursorLocation = 3
goCN.CommandTimeout = 60
goCN.Open
For N = 1 To 3
goCN.Execute MyUpdates (N)
Next
goCN.Close
Next
Set goCN = Nothing
%>
With best regards,
--
Should you have any questions, please don't hesitate to contact me.
If you response to an email, please quote the complete message.
http://1click.lv
"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
>
>
| |
| Tony Toews 2004-09-24, 3:55 am |
| "Scotter" <spam@spam.com> wrote:
>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.
See the TempTables.MDB page at my website which illustrates how to use
a temporary MDB in your app.
http://www.granite.ab.ca/access/temptables.htm
This assumes you can run Access on the IIS server or link to the
directory containing the Access MDBs as a share from another system
which does have Access installed.
If access via is via a VPN or T1 or link slower than 10 mbps as a
share this might be too slow to effectively do the job. Depending on
the number of records in the table. Access does not work well over
VPNs, T1s and such unlike SQL Server.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
| |
| Scotter 2004-09-24, 3:55 am |
| ok NOW we are getting down to business.
Since no one knows of software to do this, yeah, I've written something.
My latest lil hitch is how to tell a new field to have an index.
Here is the part of my code that does that part.
See the comment that says " 'turn index on "? That is where I need to
somehow tell it to create an index for this new column.
THE CODE:
if (n_found=0) then
set objColumn = server.CreateObject("ADOX.Column")
if (left(s_new_field_name,2)="ID") then set objIndex =
server.CreateObject("ADOX.Index")
objColumn.Name = s_new_field_name
objColumn.Type = s_new_field_type
if (s_new_field_size<>"") then objColumn.DefinedSize =
s_new_field_size
'if (s_new_field_required<>"") then objColumn.Properties("Nullable")
= true
'if (s_new_field_required<>"") then
objColumn.attributes=s_new_field_required
set objColumn.ParentCatalog=Cat ' must set before setting properties
if (s_new_field_default_value<>"") then
objColumn.properties("Default")=s_new_field_default_value
if (s_new_field_type <> adBoolean) then
if (s_new_field_null_ok=true) then
objColumn.properties("Nullable")=s_new_field_null_ok
end if
if (left(s_new_field_name,2)="ID") then
'turn index on
end if
'.properties("Autoincrement")=true
objTable.Columns.Append objColumn
set objColumn=nothing
Response.Write("<td>field added: " & s_new_field_name & "</td>")
else
Response.Write("<td>field already exists</td>")
end if
| |
| Scotter 2004-09-24, 3:55 am |
| Ah thanks, Tony, for the validation :)
"Tony Toews" <ttoews@telusplanet.net> wrote in message
news:1ot6l01jid9nph97uq7a7p2lpi5n18mc8d@
4ax.com...
>
> Makes sense to me. It can be more work in one way, as you are finding
> out but given your situation having separate MDBs makes a lot of
> sense.
>
> Also given that Access doesn't handle a large volume of concurrent
> updates/inserts, this minimizes the risks of corruptions and reduces
> it to just one of the clients at a time.
>
> Do note that "large volume of concurrent updates/inserts" varies
> betweens systems, developers and other variables. And differs between
> IIS usage vs thick client, ie Access FE MDB/MDE usage.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
| |
| Bob Barrows [MVP] 2004-09-24, 3:55 am |
| Scotter wrote:
> ok NOW we are getting down to business.
> Since no one knows of software to do this,
What's wrong with builtin replication?
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
| |
| Ray Costanzo [MVP] 2004-09-24, 3:55 am |
| As much as I admire SQL Server, DB/2 is still king in the banking world.
Ray at home
"Scotter" <spam@spam.com> wrote in message
news:F5K4d.16840$Qb.9583@fe2.texas.rr.com...
> not tracking money.
> Banking *associations* and other bank-related customers.
> If I were hosting an actual BANK, I'd be using SQL Server back end.
>
>
> "dlbjr" <oops@iforgot.com> wrote in message
> news:u7DxcecoEHA.3460@tk2msftngp13.phx.gbl...
>
>
| |
| Jeff Cochran 2004-09-24, 3:55 am |
| On Thu, 23 Sep 2004 22:04:26 GMT, "Scotter" <spam@spam.com> wrote:
>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.
There are no commercial applications designed to do what you do using
ASP. Since you posted to six different groups, perhaps you can now
drop the ASP groups and find a solution elsewhere. Or if it must be
ASP, stop posting to any but the relevant one, asp.db.
For your purposes, you will likely need to write your own
install/patch routines, but commercial patch integration software may
suit your needs. It's not ASP though.
Jeff
| |
| Jeff Cochran 2004-09-24, 3:55 am |
| On Fri, 24 Sep 2004 01:40:08 GMT, "Scotter" <spam@spam.com> wrote:
>ok NOW we are getting down to business.
>Since no one knows of software to do this, yeah, I've written something.
>My latest lil hitch is how to tell a new field to have an index.
>Here is the part of my code that does that part.
>See the comment that says " 'turn index on "? That is where I need to
>somehow tell it to create an index for this new column.
For that simple a change replicating the structure can be done from
within Access. Indexes and all. Plus if your databases were designed
for it, you could replicate saved queries and update a significant
amount of code as well with the same process. Do you have to use
ASP/.NET for your changes (you posted to both ASP and .NET groups...)?
Jeff
>THE CODE:
>
> if (n_found=0) then
> set objColumn = server.CreateObject("ADOX.Column")
> if (left(s_new_field_name,2)="ID") then set objIndex =
>server.CreateObject("ADOX.Index")
> objColumn.Name = s_new_field_name
> objColumn.Type = s_new_field_type
> if (s_new_field_size<>"") then objColumn.DefinedSize =
>s_new_field_size
> 'if (s_new_field_required<>"") then objColumn.Properties("Nullable")
>= true
> 'if (s_new_field_required<>"") then
>objColumn.attributes=s_new_field_required
> set objColumn.ParentCatalog=Cat ' must set before setting properties
> if (s_new_field_default_value<>"") then
>objColumn.properties("Default")=s_new_field_default_value
> if (s_new_field_type <> adBoolean) then
> if (s_new_field_null_ok=true) then
>objColumn.properties("Nullable")=s_new_field_null_ok
> end if
>
> if (left(s_new_field_name,2)="ID") then
> 'turn index on
> end if
>
> '.properties("Autoincrement")=true
> objTable.Columns.Append objColumn
> set objColumn=nothing
>
> Response.Write("<td>field added: " & s_new_field_name & "</td>")
> else
> Response.Write("<td>field already exists</td>")
> end if
>
>
>
>
| |
| Stefan Berglund 2004-09-24, 3:55 am |
| On Thu, 23 Sep 2004 22:37:57 -0400, "Ray Costanzo [MVP]" <my
first name at lane 34 dot commercial> wrote:
in <#OXif8doEHA.132@TK2MSFTNGP14.phx.gbl>
>As much as I admire SQL Server, DB/2 is still king in the banking world.
>
>Ray at home
If you think about it, that's actually quite a  statement.
---
Stefan Berglund
| |
| Scotter 2004-09-24, 3:55 am |
| I didn't realize replication would do this.
Now I go investigate in that direction.
THANKS!
| |
| [MSFT] 2004-09-24, 3:55 am |
| To add a index:
if (left(s_new_field_name,2)="ID") then
objIndex.NAME = "myindex"
objIndex.COLUMNS.APPEND(s_new_field_name)
objTable.INDEXES.APPEND(objIndex)
end if
Also, I agree Andrew that you need to repeat these command on all tables
touched in your applications.
Luke
| |
| Douglas J. Steele 2004-09-24, 8:55 am |
| "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:eoxxDydoEHA.3464@tk2msftngp13.phx.gbl...
> Scotter wrote:
>
> What's wrong with builtin replication?
Replication works on the data contents as well.
If each database has data for different clients, you're going to end up with
all of the data being copied into all of the databases.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
| |
| Bob Barrows [MVP] 2004-09-24, 3:55 pm |
| Douglas J. Steele wrote:
> "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
> news:eoxxDydoEHA.3464@tk2msftngp13.phx.gbl...
>
> Replication works on the data contents as well.
>
> If each database has data for different clients, you're going to end
> up with all of the data being copied into all of the databases.
My mistake, I guess. I thought there was a way to do selective replication
(specifically, Design replication), but it's been so long since I worked
with Access ...
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
| |
| Douglas J. Steele 2004-09-24, 3:55 pm |
| "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:u6iO8pjoEHA.1460@TK2MSFTNGP12.phx.gbl...
> Douglas J. Steele wrote:
>
> My mistake, I guess. I thought there was a way to do selective replication
> (specifically, Design replication), but it's been so long since I worked
> with Access ...
Actually, I'm not a replication guru, so it's possible you're right that
it's possible. However, I don't think setting everything up as replicable is
necessarily the way to go.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
| |
| Ray Costanzo [MVP] 2004-09-24, 8:55 pm |
|
"Stefan Berglund" <keepit@in.thegroups> wrote in message
news:qj37l0pmlqgdmdqpr5lhq3l7v3d6768nr0@
4ax.com...
>
>
> If you think about it, that's actually quite a statement.
Nah, I don't think so. IBM's high end stuff is absolutely rock solid, imo.
And it has been around in the enterprise environment for a really long time.
If Microsoft wants to try to chip away at that, which I believe they can do,
they have to be patient about it. Banks, as other companies also are, I'm
sure, have lots of "dinosaurs" as IT directors who have been dealing with
0S/nnn longer than most of their employees have been alive. I'm sure they
laugh at SQL Server, not quite as justly as they think they are, but still
at least a little.
Ray at home
| |
| Stephen Rasey 2004-09-26, 8:55 pm |
| There is Partial Replication, where each "client" .MDB get data only for
that client.
There is a lot of advice against using replication for design changes,
however. Particularly from Michael Kaplan.
I have found you avoid a lot of problems if you follow one rule: Never
CHANGE a replicated object. Create a new one, and delete the old.
So for many application, a batch design change file may be the better
approach on non-replicated databases.
Stephen Rasey
WiserWays, LLC
Houston, TX
http://excelsig.org
|
|
|
|
|