473,804 Members | 2,116 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1398
See your other thread. Also see this: http://aspfaq.com/5004

Ray at work
"Scotter" <sp**@spam.co m> wrote in message
news:th******** *********@fe2.t exas.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.publi c.inetserver.as p.db - yes
microsoft.publi c.dotnet.genera l - completely OT for that NG
microsoft.publi c.inetserver.as p.general - yes
microsoft.publi c.vb.com - completely OT for that NG
microsoft.publi c.access.3rdpar tyusrgrp - perhaps
microsoft.publi c.access.replic ation - 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.co m> wrote in message
news:EP******** *********@fe2.t exas.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.publi c.dotnet.genera l 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******** ******@TK2MSFTN GP10.phx.gbl...
Six most applicable?.... .

microsoft.publi c.inetserver.as p.db - yes
microsoft.publi c.dotnet.genera l - completely OT for that NG
microsoft.publi c.inetserver.as p.general - yes
microsoft.publi c.vb.com - completely OT for that NG
microsoft.publi c.access.3rdpar tyusrgrp - perhaps
microsoft.publi c.access.replic ation - 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.co m> wrote in message
news:EP******** *********@fe2.t exas.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.co m> wrote in message
news:i8******** *********@fe2.t exas.rr.com...
The reason why microsoft.publi c.dotnet.genera l 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******** ******@TK2MSFTN GP10.phx.gbl...
Six most applicable?.... .

microsoft.publi c.inetserver.as p.db - yes
microsoft.publi c.dotnet.genera l - completely OT for that NG
microsoft.publi c.inetserver.as p.general - yes
microsoft.publi c.vb.com - completely OT for that NG
microsoft.publi c.access.3rdpar tyusrgrp - perhaps
microsoft.publi c.access.replic ation - 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.co m> wrote in message
news:EP******** *********@fe2.t exas.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******** ******@TK2MSFTN GP14.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.co m> wrote in message
news:i8******** *********@fe2.t exas.rr.com...
The reason why microsoft.publi c.dotnet.genera l 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******** ******@TK2MSFTN GP10.phx.gbl...
> Six most applicable?.... .
>
> microsoft.publi c.inetserver.as p.db - yes
> microsoft.publi c.dotnet.genera l - completely OT for that NG
> microsoft.publi c.inetserver.as p.general - yes
> microsoft.publi c.vb.com - completely OT for that NG
> microsoft.publi c.access.3rdpar tyusrgrp - perhaps
> microsoft.publi c.access.replic ation - 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.co m> wrote in message
> news:EP******** *********@fe2.t exas.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
1934
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 variables to be in sync since users can view the value stored on arbitrary server. So far I have tried server.execute and server.transer to execute script updating Application("SomeVariableName") value on server A in response to user's action on...
10
1368
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 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...
20
6645
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 logging onto the web server using LDAP for authentication, do most people 1) have the web server connecting to the database using its own user account (possibly through ident), and controlling access to different database entities strictly through...
2
1386
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 runs with, which gets loaded upon logon. My situation is a following: - 1 set of code which can interact with the database - 1 SQL Server instance with multiple Databases (1 per customer)
4
3565
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. Does anyone know if this can be done? Thanks
17
3557
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 populated when a user scans a label. The other is ScanDate - a date/time field that should equal the date/time of the scan (e.g. 7/31/2006 5:00:00 AM).
6
2989
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 Excel spread sheets which can be uploaded to the database using the application after some validations. But rather than Excel I was looking at Infopath with Access as the database, to create validation rules and collect data offline that can be...
4
4532
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 child apps of an IIS application and can be used by multiple users during the application life cycle and for multiple page loads for the same or different page under a root application. What I don't understand and need to know is whether that...
0
9716
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10604
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10101
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9177
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7643
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6870
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5536
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5675
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3005
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.