473,320 Members | 1,922 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

application to sync multiple MDBs on one server?

Hi -

I've got quite a few 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 MDBs designated to match one I've added some fields/tables to
OR
(b) tell all designated MDBs to have an extra 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
Jul 21 '05 #1
7 1382
See your other thread. Also see this: http://aspfaq.com/5004

Ray at work
"Scotter" <sp**@spam.com> wrote in message
news:th*****************@fe2.texas.rr.com...
Hi -

I've got quite a few 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 MDBs designated to match one I've added some fields/tables to
OR
(b) tell all designated MDBs to have an extra 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

Jul 21 '05 #2
btw I really did try to pick the six or so (out of about 17 asp/db-related I
typically peruse) most applicable newsgroups to post my message in. I
apologize if one or two were not applicable enough in your eyes. Humbly and
seriously.
The point of not crossposting is to not bombard others with extraneous data,
right?
Well this little debate about whether I even need multiple MDBs and you all
posting advice about cross-posting is taking up more space than if you all
had just either answered my question or not said anything.
So now I'm also posting extra messages just to defend myself.
Jul 21 '05 #3
Six most applicable?.....

microsoft.public.inetserver.asp.db - yes
microsoft.public.dotnet.general - completely OT for that NG
microsoft.public.inetserver.asp.general - yes
microsoft.public.vb.com - completely OT for that NG
microsoft.public.access.3rdpartyusrgrp - perhaps
microsoft.public.access.replication - perhaps

I don't mean to offend but, what you _should_ have done instead, is just
post it to the inetserver.asp.general NG, and if it was necessary, you would
have been directed to a more "applicable" newsgroup from there.

--

Regards

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

Keeping it FREE!
"Scotter" <sp**@spam.com> wrote in message
news:EP*****************@fe2.texas.rr.com...
btw I really did try to pick the six or so (out of about 17 asp/db-related I typically peruse) most applicable newsgroups to post my message in. I
apologize if one or two were not applicable enough in your eyes. Humbly and seriously.
The point of not crossposting is to not bombard others with extraneous data, right?
Well this little debate about whether I even need multiple MDBs and you all posting advice about cross-posting is taking up more space than if you all
had just either answered my question or not said anything.
So now I'm also posting extra messages just to defend myself.

Jul 21 '05 #4
The reason why microsoft.public.dotnet.general MAY not be off topic is
because I'm looking for someone who is a .net programmer who might have
either written a Web CMS like mine that uses MDB back ends and found
software like I'm looking for OR he wrote it himself like I've already half
done.
So please, just because you don't necessarily see or imagine how something
can apply or work don't assume it doesn't apply or work.
Same with the other newsgroup(s) you assume are off topic for my post.
I really really just want peace here and an answer to my original question.
"Steven Burn" <pv*@noyb.com> wrote in message
news:eQ**************@TK2MSFTNGP10.phx.gbl...
Six most applicable?.....

microsoft.public.inetserver.asp.db - yes
microsoft.public.dotnet.general - completely OT for that NG
microsoft.public.inetserver.asp.general - yes
microsoft.public.vb.com - completely OT for that NG
microsoft.public.access.3rdpartyusrgrp - perhaps
microsoft.public.access.replication - perhaps

I don't mean to offend but, what you _should_ have done instead, is just
post it to the inetserver.asp.general NG, and if it was necessary, you
would
have been directed to a more "applicable" newsgroup from there.

--

Regards

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

Keeping it FREE!
"Scotter" <sp**@spam.com> wrote in message
news:EP*****************@fe2.texas.rr.com...
btw I really did try to pick the six or so (out of about 17
asp/db-related

I
typically peruse) most applicable newsgroups to post my message in. I
apologize if one or two were not applicable enough in your eyes. Humbly

and
seriously.
The point of not crossposting is to not bombard others with extraneous

data,
right?
Well this little debate about whether I even need multiple MDBs and you

all
posting advice about cross-posting is taking up more space than if you
all
had just either answered my question or not said anything.
So now I'm also posting extra messages just to defend myself.


Jul 21 '05 #5
> don't assume it doesn't apply or work.

Oh crikey..... I wouldn't even contemplating assuming that, or anything else
for that matter ;o)

As for your original Q (and your probably gonna hate me now), AFAIK, there
is no software available that will do what you are wanting. Instead (and you
probably already know this), you'll need to write a script that opens each
DB, and adds the fields required.

--

Regards

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

Keeping it FREE!
"Scotter" <sp**@spam.com> wrote in message
news:i8*****************@fe2.texas.rr.com...
The reason why microsoft.public.dotnet.general MAY not be off topic is
because I'm looking for someone who is a .net programmer who might have
either written a Web CMS like mine that uses MDB back ends and found
software like I'm looking for OR he wrote it himself like I've already half done.
So please, just because you don't necessarily see or imagine how something
can apply or work don't assume it doesn't apply or work.
Same with the other newsgroup(s) you assume are off topic for my post.
I really really just want peace here and an answer to my original question.

"Steven Burn" <pv*@noyb.com> wrote in message
news:eQ**************@TK2MSFTNGP10.phx.gbl...
Six most applicable?.....

microsoft.public.inetserver.asp.db - yes
microsoft.public.dotnet.general - completely OT for that NG
microsoft.public.inetserver.asp.general - yes
microsoft.public.vb.com - completely OT for that NG
microsoft.public.access.3rdpartyusrgrp - perhaps
microsoft.public.access.replication - perhaps

I don't mean to offend but, what you _should_ have done instead, is just
post it to the inetserver.asp.general NG, and if it was necessary, you
would
have been directed to a more "applicable" newsgroup from there.

--

Regards

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

Keeping it FREE!
"Scotter" <sp**@spam.com> wrote in message
news:EP*****************@fe2.texas.rr.com...
btw I really did try to pick the six or so (out of about 17
asp/db-related

I
typically peruse) most applicable newsgroups to post my message in. I
apologize if one or two were not applicable enough in your eyes. Humbly

and
seriously.
The point of not crossposting is to not bombard others with extraneous

data,
right?
Well this little debate about whether I even need multiple MDBs and you

all
posting advice about cross-posting is taking up more space than if you
all
had just either answered my question or not said anything.
So now I'm also posting extra messages just to defend myself.



Jul 21 '05 #6
Thanks, Steven, for getting back to my original question! Whew!!!!
Yeah, if you read that question again, you'll see I mentioned I already
started writing this app.
I agree with the reasons behind why you think no one else has probably
written an app like this.
I think I may just switch gears and beef up my lil MDB-structure-copier-app
until it does at least what I need.
Thanks

"Steven Burn" <pv*@noyb.com> wrote in message
news:eV**************@TK2MSFTNGP14.phx.gbl...
don't assume it doesn't apply or work.


Oh crikey..... I wouldn't even contemplating assuming that, or anything
else
for that matter ;o)

As for your original Q (and your probably gonna hate me now), AFAIK, there
is no software available that will do what you are wanting. Instead (and
you
probably already know this), you'll need to write a script that opens each
DB, and adds the fields required.

--

Regards

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

Keeping it FREE!
"Scotter" <sp**@spam.com> wrote in message
news:i8*****************@fe2.texas.rr.com...
The reason why microsoft.public.dotnet.general MAY not be off topic is
because I'm looking for someone who is a .net programmer who might have
either written a Web CMS like mine that uses MDB back ends and found
software like I'm looking for OR he wrote it himself like I've already

half
done.
So please, just because you don't necessarily see or imagine how
something
can apply or work don't assume it doesn't apply or work.
Same with the other newsgroup(s) you assume are off topic for my post.
I really really just want peace here and an answer to my original

question.


"Steven Burn" <pv*@noyb.com> wrote in message
news:eQ**************@TK2MSFTNGP10.phx.gbl...
> Six most applicable?.....
>
> microsoft.public.inetserver.asp.db - yes
> microsoft.public.dotnet.general - completely OT for that NG
> microsoft.public.inetserver.asp.general - yes
> microsoft.public.vb.com - completely OT for that NG
> microsoft.public.access.3rdpartyusrgrp - perhaps
> microsoft.public.access.replication - perhaps
>
> I don't mean to offend but, what you _should_ have done instead, is
> just
> post it to the inetserver.asp.general NG, and if it was necessary, you
> would
> have been directed to a more "applicable" newsgroup from there.
>
> --
>
> Regards
>
> Steven Burn
> Ur I.T. Mate Group
> www.it-mate.co.uk
>
> Keeping it FREE!
>
>
> "Scotter" <sp**@spam.com> wrote in message
> news:EP*****************@fe2.texas.rr.com...
>> btw I really did try to pick the six or so (out of about 17
>> asp/db-related
> I
>> typically peruse) most applicable newsgroups to post my message in. I
>> apologize if one or two were not applicable enough in your eyes.
>> Humbly
> and
>> seriously.
>> The point of not crossposting is to not bombard others with extraneous
> data,
>> right?
>> Well this little debate about whether I even need multiple MDBs and
>> you
> all
>> posting advice about cross-posting is taking up more space than if you
>> all
>> had just either answered my question or not said anything.
>> So now I'm also posting extra messages just to defend myself.
>>
>>
>
>



Jul 21 '05 #7
Hello,

I have replied you in another thread. If you have any further questions,
please reply in that thread.

Thanks,

Luke

Jul 21 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Art | last post by:
Can I update Application("SomeVariableName") on server A in response to user's action on server B? There is no problem in updating the same variable on server B, of course, but we would like both...
10
by: Scotter | last post by:
Hi - I've got quite a few 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...
20
by: Keith G. Murphy | last post by:
I'm trying to get a feel for what most people are doing or consider best practice. Given a mod_perl application talking to a PostgreSQL database on the same host, where different users are...
2
by: Gabriël | last post by:
Hi, Can anyone point me to a article of product about using an application hosted on a webserver for multiple customers? So everything is the same except for the connection string each customer...
4
by: RoadRunner | last post by:
Hi, I have a question. I am asked to produce a global search of a given corporate name, in more that one database. Each database has different table names and different field names in the tables....
17
by: Timothy.Rybak | last post by:
Hello all, This is my first attempt at an application, so kid gloves are appreciated. I need to make a very simple form that only has a few elements. One is TraceCode - a text field that is...
6
by: Senthil | last post by:
Hi All We are having a VB application on SQL. But we need to collect information from persons who will be offline to verify data and insert new data. Generally they will be entering the data in...
4
by: Dave | last post by:
I have a global.asax file with Application_Start defined and create some static data there and in another module used in the asp.net application and I realize that static data is shared amongst...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.