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 37 1281
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" <sp**@spam.com> wrote in message
news:ED******************@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" <sp**@spam.com> wrote in message
news:ED******************@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" <sp**@spam.com> wrote in message
news:m7*****************@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" <pv*@noyb.com> wrote in message
news:%2****************@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" <sp**@spam.com> wrote in message news:m7*****************@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).
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.com> 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.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" <pv*@noyb.com> wrote in message news:%2****************@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" <sp**@spam.com> wrote in message news:m7*****************@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).
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*************@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" <sp**@spam.com> 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.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" <pv*@noyb.com> wrote in message news:%2****************@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" <sp**@spam.com> wrote in message news:m7*****************@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" <sp**@spam.com> wrote in message
news:jv******************@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!
I see you saying absolutely no need for 20 databases and I'm wondeirng if
maybe you confused 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" <pv*@noyb.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl... "Scotter" <sp**@spam.com> wrote in message news:jv******************@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" <sp**@spam.com> wrote in message
news:KL*****************@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!
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" <sp**@spam.com> wrote in message
news:gU*****************@fe2.texas.rr.com... I see you saying absolutely no need for 20 databases and I'm wondeirng if maybe you confused 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" <pv*@noyb.com> wrote in message news:%2****************@TK2MSFTNGP10.phx.gbl... "Scotter" <sp**@spam.com> wrote in message news:jv******************@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!
Just let it go!
Some work harder than smarter.
dlbjr
Pleading sagacious indoctrination!
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" <pv*@noyb.com> wrote in message
news:ed**************@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" <sp**@spam.com> wrote in message news:gU*****************@fe2.texas.rr.com... I see you saying absolutely no need for 20 databases and I'm wondeirng if maybe you confused 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" <pv*@noyb.com> wrote in message news:%2****************@TK2MSFTNGP10.phx.gbl... > "Scotter" <sp**@spam.com> wrote in message > news:jv******************@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 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"
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" <sp**@spam.com> wrote in message
news:06******************@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" <pv*@noyb.com> wrote in message news:ed**************@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" <sp**@spam.com> wrote in message news:gU*****************@fe2.texas.rr.com... I see you saying absolutely no need for 20 databases and I'm wondeirng
if maybe you confused 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" <pv*@noyb.com> wrote in message news:%2****************@TK2MSFTNGP10.phx.gbl... > "Scotter" <sp**@spam.com> wrote in message > news:jv******************@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! > > >
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!
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" <oo**@iforgot.com> wrote in message
news:Om**************@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!
Send me links to your product. I'm on all the software committees at the
bank where I work. ra*@securitynat.com
Ray at work
"Scotter" <sp**@spam.com> wrote in message
news:_p*****************@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" <oo**@iforgot.com> wrote in message news:Om**************@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!
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!
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" <oo**@iforgot.com> wrote in message
news:u7**************@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!
"Scotter" <sp**@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
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" <sp**@spam.com> wrote in message
news:ED******************@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" <sp**@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
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_defaul t_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
Ah thanks, Tony, for the validation :)
"Tony Toews" <tt****@telusplanet.net> wrote in message
news:1o********************************@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
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"
As much as I admire SQL Server, DB/2 is still king in the banking world.
Ray at home
"Scotter" <sp**@spam.com> wrote in message
news:F5*****************@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" <oo**@iforgot.com> wrote in message news:u7**************@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!
On Thu, 23 Sep 2004 22:04:26 GMT, "Scotter" <sp**@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
On Fri, 24 Sep 2004 01:40:08 GMT, "Scotter" <sp**@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_defau lt_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
I didn't realize replication would do this.
Now I go investigate in that direction.
THANKS!
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
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eo**************@tk2msftngp13.phx.gbl... 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?
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!)
Douglas J. Steele wrote: "Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message news:eo**************@tk2msftngp13.phx.gbl... 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?
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"
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:u6**************@TK2MSFTNGP12.phx.gbl... Douglas J. Steele wrote: "Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message news:eo**************@tk2msftngp13.phx.gbl... 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?
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 ...
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!)
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
read salmos y proverbios from the bible
"Scotter" <sp**@spam.com> escribió en el mensaje
news:ED******************@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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Scotter |
last post by:
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...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |