473,703 Members | 3,832 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Jet 4 Replication Service Pack

See:

Updated version of the Microsoft Jet 4.0 Service Pack 8
replication
files is available in the Download Center
http://support.microsoft.com/?scid=kb;en-us;321076

This includes the Jet 4 synchronizer.

This allows anyone to do indirect replication, even without
purchasing the Office Developer tools. You don't get Replication
Manager, but ReplMan has never been all that great a UI to managing
replication, anyway.

With mstran40.exe and JRO and/or the TSI Synchronizer, you should be
able to do any Jet indirect synchronization (or Internet synchs, as
mstrai40.exe is also in the update).

This is an important change in MS policy, distributing the
synchronizer outside the developer tools. I have discovered that
it's actually been a around a while, since before Jet 4 SP6, as can
be seen from this article about an error that an earlier fix of
these files addressed:

http://support.microsoft.com/kb/320803/

And, just looking at the first URL, I see it is dated over a year
ago, but I just learned about this in Woody's Office Watch, which
reports it as an update related to the new Office 2003 SP2.

Not sure what's going on here, but it makes it possible for anyone
to do indirect replication without needing to have the Office
developer tools.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #1
9 3928
David,

What is indirect replication and where can I get more information about it?

Thanks!

Steve
"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:Xn******** *************** ***********@216 .196.97.142...
See:

Updated version of the Microsoft Jet 4.0 Service Pack 8
replication
files is available in the Download Center
http://support.microsoft.com/?scid=kb;en-us;321076

This includes the Jet 4 synchronizer.

This allows anyone to do indirect replication, even without
purchasing the Office Developer tools. You don't get Replication
Manager, but ReplMan has never been all that great a UI to managing
replication, anyway.

With mstran40.exe and JRO and/or the TSI Synchronizer, you should be
able to do any Jet indirect synchronization (or Internet synchs, as
mstrai40.exe is also in the update).

This is an important change in MS policy, distributing the
synchronizer outside the developer tools. I have discovered that
it's actually been a around a while, since before Jet 4 SP6, as can
be seen from this article about an error that an earlier fix of
these files addressed:

http://support.microsoft.com/kb/320803/

And, just looking at the first URL, I see it is dated over a year
ago, but I just learned about this in Woody's Office Watch, which
reports it as an update related to the new Office 2003 SP2.

Not sure what's going on here, but it makes it possible for anyone
to do indirect replication without needing to have the Office
developer tools.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #2
"PC Datasheet" <no****@nospam. spam> wrote in
news:ea******** *********@newsr ead2.news.atl.e arthlink.net:
What is indirect replication and where can I get more information
about it?


In answering, I'll assume you already know what Jet replication is
and what it does.

Jet replication via the Access menus is intended for use over a LAN,
because when it synchronizes two replicas, it opens both of them.

If you are remote from the replica you are synchronizing with, you
are likely to have much-reduced bandwidth, which makes pulling the
entire remote replica across the wire not only a performance
bottleneck, but also rather dangerous, because of the possibility of
a droppeed connection, which could corrupt the remote database.

That kind of replication is called "direct replication."

To address the problems of direct replication, Microsoft created two
alternative synchronization methods, indirect and Internet
replication. Both work by using a process running on either end of
the synchronization that opens the replica locally, and all
communication is between the two synchronizers. Indirect replication
uses MSTRAN>>.EXE and Internet replication use MSTRAIXX.EXE (where
XX is the Jet version, 40 for Jet 4, 35 for 3.5).

Indirect replication uses a dropbox on each end that is accessible
to the remote synchronizer. If you've got ReplicaA and ReplicaB,
ReplicaA has DropboxA and ReplicaB has DropBoxB. SynchronizerA
communicates with SynchronizerB and determines what generations need
to be sent (based on each synchronizer reading its local replica's
replication tables). SymchronizerA will then drop message files and
small MDBs into DropBoxB that include all the changes in ReplicaA
that ReplicaB does not have. SynchronizerB then applies the data in
DropBoxB to ReplicaB, then places files in DropBoxA for
SynchronizerA to apply to ReplicaA. This is a reiterative process,
because certain changes have to be successful before certain others
can happen (e.g., a parent record must be successfully inserted
before a child record attached to it can be inserted), and so you
can have a cycle of several round-trips between the two
synchronizers before the replicas reach a state where they have
identical data.

The advantage of indirect replication over direct is that the only
data that goes across the wire is the changes (actually, the data
necessary to apply the changes, which is going to be greater than
the content of the changes themselves, but substantially less than
if you pulled the whole remote replica across the wire). A direct
replication over a slow connection can take hours, assuming it
succeeds. An indirect synch of the same data usually takes less than
10 minutes, and usually substantially less (when replicas are
synching regularly, e.g., daily, it often takes 2 or 3 minutes, but
it depends on the number and type of changes being synched).

Internet replication does basically the same thing, but uses FTP to
communicate, rather than the SMB networking that indirect
replication is based on. The problem from my point of view with
Internet replication is that it has hardwired dependencies on IIS --
you must use the IIS FTP service for it. You can't use some other
FTP service. And it requires that IIS (to support the FTP service)
be running on all PCs that do the synchronizing. That means that if
you want to set up laptops to synch with the mothership via Internet
replication, those laptops have to have IIS installed and running.

To me, that's an unacceptable requirement because:

1. it's an additional administrative requirement that is hard to
manage remotely.

2. IIS is the most unsafe widely-used HTTP server out there. Yes, MS
has addressed a lot of the problems that were there that led to the
worms that propagated so widely a couple of years ago, but I'm not
convinced. Apache is a much safer and more secure HTTP server that
is not intimately hardwired into the OS, but you can't use it, or
any alternative FTP server.

3. because of the dependencies outside of Access and outside of file
system permissions, you now have a dependency on a monolithic
component that really oughtn't be running on workstations at all.
That dependency makes Internet replication particularly fragile,
since not only can file access configuration issues cause problems
(as they also can with indirect replication), but you also add in
the problems of properly configuring the IIS/FTP services, which,
from the history of problems we've seen reported in
microsoft.publi c.access.replic ation, is not a triviality at all.

Now, the original problem with indirect replication was that it
required an SMB networking connection. That meant the Internet was
out of the question -- you either needed a WAN that was NETBios
end-to-end, or you needed some form of dialup networking (which was
always fine for indirect replication, even at 28.8). This meant
dialin servers and other administrative headaches and expenses in
order to support many remote users.

However, these days with VPNs being widely in use and so easy to set
up from within Windows, the solution for indirect replication is to
run it across the Internet over a VPN. It's not terribly difficult
once the VPN infrastructure is in place (as it already is in a large
number of offices).

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #3
Thanks, David! I really appreciate the indepth discussion.

Steve
"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:Xn******** *************** ***********@216 .196.97.142...
"PC Datasheet" <no****@nospam. spam> wrote in
news:ea******** *********@newsr ead2.news.atl.e arthlink.net:
What is indirect replication and where can I get more information
about it?


In answering, I'll assume you already know what Jet replication is
and what it does.

Jet replication via the Access menus is intended for use over a LAN,
because when it synchronizes two replicas, it opens both of them.

If you are remote from the replica you are synchronizing with, you
are likely to have much-reduced bandwidth, which makes pulling the
entire remote replica across the wire not only a performance
bottleneck, but also rather dangerous, because of the possibility of
a droppeed connection, which could corrupt the remote database.

That kind of replication is called "direct replication."

To address the problems of direct replication, Microsoft created two
alternative synchronization methods, indirect and Internet
replication. Both work by using a process running on either end of
the synchronization that opens the replica locally, and all
communication is between the two synchronizers. Indirect replication
uses MSTRAN>>.EXE and Internet replication use MSTRAIXX.EXE (where
XX is the Jet version, 40 for Jet 4, 35 for 3.5).

Indirect replication uses a dropbox on each end that is accessible
to the remote synchronizer. If you've got ReplicaA and ReplicaB,
ReplicaA has DropboxA and ReplicaB has DropBoxB. SynchronizerA
communicates with SynchronizerB and determines what generations need
to be sent (based on each synchronizer reading its local replica's
replication tables). SymchronizerA will then drop message files and
small MDBs into DropBoxB that include all the changes in ReplicaA
that ReplicaB does not have. SynchronizerB then applies the data in
DropBoxB to ReplicaB, then places files in DropBoxA for
SynchronizerA to apply to ReplicaA. This is a reiterative process,
because certain changes have to be successful before certain others
can happen (e.g., a parent record must be successfully inserted
before a child record attached to it can be inserted), and so you
can have a cycle of several round-trips between the two
synchronizers before the replicas reach a state where they have
identical data.

The advantage of indirect replication over direct is that the only
data that goes across the wire is the changes (actually, the data
necessary to apply the changes, which is going to be greater than
the content of the changes themselves, but substantially less than
if you pulled the whole remote replica across the wire). A direct
replication over a slow connection can take hours, assuming it
succeeds. An indirect synch of the same data usually takes less than
10 minutes, and usually substantially less (when replicas are
synching regularly, e.g., daily, it often takes 2 or 3 minutes, but
it depends on the number and type of changes being synched).

Internet replication does basically the same thing, but uses FTP to
communicate, rather than the SMB networking that indirect
replication is based on. The problem from my point of view with
Internet replication is that it has hardwired dependencies on IIS --
you must use the IIS FTP service for it. You can't use some other
FTP service. And it requires that IIS (to support the FTP service)
be running on all PCs that do the synchronizing. That means that if
you want to set up laptops to synch with the mothership via Internet
replication, those laptops have to have IIS installed and running.

To me, that's an unacceptable requirement because:

1. it's an additional administrative requirement that is hard to
manage remotely.

2. IIS is the most unsafe widely-used HTTP server out there. Yes, MS
has addressed a lot of the problems that were there that led to the
worms that propagated so widely a couple of years ago, but I'm not
convinced. Apache is a much safer and more secure HTTP server that
is not intimately hardwired into the OS, but you can't use it, or
any alternative FTP server.

3. because of the dependencies outside of Access and outside of file
system permissions, you now have a dependency on a monolithic
component that really oughtn't be running on workstations at all.
That dependency makes Internet replication particularly fragile,
since not only can file access configuration issues cause problems
(as they also can with indirect replication), but you also add in
the problems of properly configuring the IIS/FTP services, which,
from the history of problems we've seen reported in
microsoft.publi c.access.replic ation, is not a triviality at all.

Now, the original problem with indirect replication was that it
required an SMB networking connection. That meant the Internet was
out of the question -- you either needed a WAN that was NETBios
end-to-end, or you needed some form of dialup networking (which was
always fine for indirect replication, even at 28.8). This meant
dialin servers and other administrative headaches and expenses in
order to support many remote users.

However, these days with VPNs being widely in use and so easy to set
up from within Windows, the solution for indirect replication is to
run it across the Internet over a VPN. It's not terribly difficult
once the VPN infrastructure is in place (as it already is in a large
number of offices).

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #4
David W. Fenton wrote:
2. IIS is the most unsafe widely-used HTTP server out there. Yes, MS
has addressed a lot of the problems that were there that led to the
worms that propagated so widely a couple of years ago, but I'm not
convinced. Apache is a much safer and more secure HTTP server that
is not intimately hardwired into the OS, but you can't use it, or
any alternative FTP server.
...
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc


Mike Shelton from Microsoft stated that SQL Server 2005 does not need
to use IIS. Perhaps I am taking this out of context. If true, would
that mean that replication using SQL Server 2005 will not be as
problematic as it was with earlier versions?

James A. Fortune

Nov 13 '05 #5
ji********@comp umarc.com wrote in
news:11******** *************@z 14g2000cwz.goog legroups.com:
David W. Fenton wrote:
2. IIS is the most unsafe widely-used HTTP server out there. Yes,
MS has addressed a lot of the problems that were there that led
to the worms that propagated so widely a couple of years ago, but
I'm not convinced. Apache is a much safer and more secure HTTP
server that is not intimately hardwired into the OS, but you
can't use it, or any alternative FTP server.


Mike Shelton from Microsoft stated that SQL Server 2005 does not
need to use IIS. Perhaps I am taking this out of context. If
true, would that mean that replication using SQL Server 2005 will
not be as problematic as it was with earlier versions?


I haven't a clue. I know zilch about SQL Server replication -- I'm
talking about Jet replication, one type of which (Internet
replication) is hardwired to use IIS's FTP services.

SQL Server is wholly unrelated.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #6
David W. Fenton wrote:
ji********@comp umarc.com wrote in
news:11******** *************@z 14g2000cwz.goog legroups.com:
David W. Fenton wrote:
2. IIS is the most unsafe widely-used HTTP server out there. Yes,
MS has addressed a lot of the problems that were there that led
to the worms that propagated so widely a couple of years ago, but
I'm not convinced. Apache is a much safer and more secure HTTP
server that is not intimately hardwired into the OS, but you
can't use it, or any alternative FTP server.


Mike Shelton from Microsoft stated that SQL Server 2005 does not
need to use IIS. Perhaps I am taking this out of context. If
true, would that mean that replication using SQL Server 2005 will
not be as problematic as it was with earlier versions?


I haven't a clue. I know zilch about SQL Server replication -- I'm
talking about Jet replication, one type of which (Internet
replication) is hardwired to use IIS's FTP services.

SQL Server is wholly unrelated.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc


I know zilch about SQL Server replication also, but that implies I
don't know if it's wholly unrelated or not. Perhaps someone can
enlighten us. Are they related? Is there a URL that explains the
differences? A friend of mine uses Jet replication a lot. After
seeing some of the nasty problems Jet replication can cause I'm sure
I'll never want to use any kind of Jet replication until better ways
are found to implement it. Perhaps you have encountered fewer
problems. I realize that MS providing the capability of replication in
Access was a difficult problem in general. Do you really recommend any
kind of Jet replication? Do you know of any companies that are using
it without having lots of problems?

Thanks in advance,

James A. Fortune

Nov 13 '05 #7
ji********@comp umarc.com wrote in
news:11******** **************@ z14g2000cwz.goo glegroups.com:
David W. Fenton wrote:
ji********@comp umarc.com wrote in
news:11******** *************@z 14g2000cwz.goog legroups.com:
> David W. Fenton wrote:
>> 2. IIS is the most unsafe widely-used HTTP server out there.
>> Yes, MS has addressed a lot of the problems that were there
>> that led to the worms that propagated so widely a couple of
>> years ago, but I'm not convinced. Apache is a much safer and
>> more secure HTTP server that is not intimately hardwired into
>> the OS, but you can't use it, or any alternative FTP server.
>
> Mike Shelton from Microsoft stated that SQL Server 2005 does
> not need to use IIS. Perhaps I am taking this out of context.
> If true, would that mean that replication using SQL Server 2005
> will not be as problematic as it was with earlier versions?
I haven't a clue. I know zilch about SQL Server replication --
I'm talking about Jet replication, one type of which (Internet
replication) is hardwired to use IIS's FTP services.

SQL Server is wholly unrelated.


I know zilch about SQL Server replication also, but that implies I
don't know if it's wholly unrelated or not. Perhaps someone can
enlighten us. Are they related? . . .


Not in any real way. However, my understanding is that some of the
people on the Jet replication team migrated over to SQL Server to
implement replication there. That is, Jet replication came first,
and SQL Server replication was added later. SQL Server replication
started out as one-way replication, the kind provided by MySQL and
PostgreSQL, which is in database servers for the purpose of
providing redundancy and load balancing, not to support editing at
multiple sites. Merge replication was added in the version of SQL
Server after basic replication was implmeneted, and I think it was
in SQL Server 7 (along with the introduction of Jet 4) that
heterogenous replication was implemented, allowing a Jet database to
participate as a synch partner in a SQL Server replication set.

They have certain things in common because both are replication, so,
of necessity, certain concepts and structures will be the same. But
other than that, they are very different. In many respects, Jet
replication is more flexible and powerful than SQL Server
replication, though SQL Server does offer transactional replication
(which Jet never can), which is better, seems to me, than anything
Jet can offer.

But merge replication on any platform is a complex operation, and
not easy or simple to implement.
. . . Is there a URL that explains the
differences? . . .
I don't know of any. Just googling a bit, I can't find anything
that's relevant as a comparison.
. . . A friend of mine uses Jet replication a lot. After
seeing some of the nasty problems Jet replication can cause I'm
sure I'll never want to use any kind of Jet replication until
better ways are found to implement it. . . .
Microsoft has basically abandoned Jet replication -- there are never
going to be any "better ways" to do it, just as there is unlikely to
ever be a better version of Jet.

It will be interesting to see if MS continues to provide replication
capability in the new Office 12 database format. My understanding of
what I've read about it is that the big change is not in Jet, but in
the Access MDB format, which will now separate out the data tables
from the Access project, with the project no longer stored in a Jet
database at all (but I could be wrong in that reading). If that's
correct, that would mean that you'd no longer be able to replicate
the front end, which is no loss, because, for all practical
purposes, you can't do that now (doing so is unstalbe and eventually
leads to corruption and loss of the whole project in almost all
cases).
. . . Perhaps you have
encountered fewer problems. . . .
Replication is difficult, but I haven't run into significant
problems with it that are insurmountable. You just have to know how
to do it right, and most people haven't taken the time to learn. Of
course, I can't really blame them, because Microsoft has never
properly documented replication best practices. The FAQs are filled
with misleading marketing speak and claims for replication that
aren't really justifiable.

The other reason replication is hard is because it has a number of
dependencies outside Access. That has never been an issue for me as
I make my living both as an Access developer and as a system
administrator, so I have the NT administration and networking skills
necessary to manage end-to-end replication scenarios. Most people
wanting to implement replication don't have that background, or in
many cases, even understand that they *need* that kind of knowledge.
. . . I realize that MS providing the
capability of replication in Access was a difficult problem in
general. Do you really recommend any kind of Jet replication? Do
you know of any companies that are using it without having lots of
problems?


My clients using replication don't have lots of problems. Now,
administering a replicated database is more involved than
administering non-replicated databases, but that's a difference
between *no adminstration* (for non-replicated) and *some*
management required.

I don't recommend Jet replication except for one scenario, and
that's the disconnected laptops scenario. For fixed remote offices,
I recommend Terminal Server hosting instead. But in 1998 when my
first trans-Atlantic replication client went live with their
database (with offices in New York and London, and two telecommuting
subcontractors) , Terminal Server was way too expensive an option in
comparison to Jet replication. That has now changed.

But for laptops in the field that need to have editable data when
not connected to the Internet, Jet replication works just fine. And
if they are going back to the main office and can synch via a LAN,
it's not even hard to set up and administer.

Replication is complicated, yes.

But it is not dangerous or unstable if properly implemented and
properly cared for. The problem is that most people don't know that
extra management is required for jet replication and because of
that, they make all the mistakes that cause things to go south.

But that's the case with Access in general -- it provides powerful
functionality that any number of novices often mis-use. That doesn't
mean there's something wrong with Access or with the basic
technologies. Indeed, it means that Access is remarkably forgiving
of error in even allowing it to work WRONG.

Jet replication works, and there is nothing comparably powerful in
any desktop database engine that I am aware of. Indeed, it's more
powerful than a lot of server databases. With power comes
complexity, and it's complexity that many people don't realize is
there until they've made mistakes in setting up Jet replication.

That's too bad, but I'd hardly blame that on Microsoft for
implementing Jet replication.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #8
David,

Do you know of a resource that would explain how to set up the Jet
Synchronizer for indirect synchronization without using ReplMan or TSI
synchronizer? I know how to use code to initiate an indirect synchronization
but how do I set up the drop box locations and let the Jet Synchronizer know
about them?

Thanks!

"David W. Fenton" <dX********@bwa y.net.invalid> wrote in message
news:Xn******** *************** ***********@216 .196.97.142...
See:

Updated version of the Microsoft Jet 4.0 Service Pack 8
replication
files is available in the Download Center
http://support.microsoft.com/?scid=kb;en-us;321076

This includes the Jet 4 synchronizer.

This allows anyone to do indirect replication, even without
purchasing the Office Developer tools. You don't get Replication
Manager, but ReplMan has never been all that great a UI to managing
replication, anyway.

With mstran40.exe and JRO and/or the TSI Synchronizer, you should be
able to do any Jet indirect synchronization (or Internet synchs, as
mstrai40.exe is also in the update).

This is an important change in MS policy, distributing the
synchronizer outside the developer tools. I have discovered that
it's actually been a around a while, since before Jet 4 SP6, as can
be seen from this article about an error that an earlier fix of
these files addressed:

http://support.microsoft.com/kb/320803/

And, just looking at the first URL, I see it is dated over a year
ago, but I just learned about this in Woody's Office Watch, which
reports it as an update related to the new Office 2003 SP2.

Not sure what's going on here, but it makes it possible for anyone
to do indirect replication without needing to have the Office
developer tools.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #9
"Tom Stoddard" <ts*******@andr ewspaper.com> wrote in
news:On******** ******@TK2MSFTN GP10.phx.gbl:
Do you know of a resource that would explain how to set up the Jet
Synchronizer for indirect synchronization without using ReplMan or
TSI synchronizer? I know how to use code to initiate an indirect
synchronization but how do I set up the drop box locations and let
the Jet Synchronizer know about them?


Nope. I've always used ReplMan for it.

It's probanly just registry keys that need to be set, but I don't
know that it's documented anywhere, and that it's the same between
versions of ReplMan.

Have you looked through JRO to see if there are methods for setting
dropbox locations? I can't see how MS could drop ReplMan in the
Visual Studio Office Developer tools if only ReplMan could be used
to set these things.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #10

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

Similar topics

0
2041
by: Philip Trim | last post by:
General Brief: 3 SQL Servers as MS SQL Server 2000 Standard Edition with Service Pack 3 All using FTP for snapshots All Servers are both Publishers and Distributors. Server A has the correct data needed to be replicated to Server B and C. Server B and C and have blank data. Server B and C are blank databases ready for replication. Server A publishers to Server B and Server C
0
2162
by: Ref | last post by:
Hi I am new with Replication I develop Now the Microsoft Server 2000 Replication And I chose Snapshot type for replication All I need to copy Part of db from Publisher via distributor to Subscriber I tried with Windows xp pro
2
1902
by: Don Peters | last post by:
In spite of trying various ways of loading .NET Framework 1.1 Service Pack 1 under my new WinXP Service pack 1, I was unable to get it to install. Typically, the installation would hang after a minute or two of execution. After many hours of frustration, I called Microsoft tech support and discussed the issue with them. After asking around, the support person said there indeed was a bug in the installation file, and to forget about it...
0
1740
by: InstallAware | last post by:
Dear Group If you want to perform a slipstreamed install of .NET Framework 1.1, including Service Pack 1, here's how. First, what do we mean by slipstreamed install? It means that version 1.1 of the framework will be installed, with the service pack 1 update already applied, "slipstreamed". There will be no need to download additional updates or install service packs as a secondary step.
10
2138
by: Daven Thrice | last post by:
I have a database that needs to be replicated over the Internet. I was hoping it would be a simple task, but apparently it is not. I've started browsing the msdn article on the topic. In the meantime, I am wondering who might be able to host a server on the Internet that meets such requirements. If anybody has had any experience with this, and/or if you can recommend a host who meets said requirements, I'd appreciate it if you'd post. ...
6
3881
by: John | last post by:
Hi We have an access app (front-end+backend) running on the company network. I am trying to setup replication for laptop users who go into field and need the data synched between their laptops and the server upon return to the office. I am planning it this; Move all access tables to sql server and then link the tables to access front-end mdb app (using odbc?). Copy the same setup (access front end + sql backend) onto each laptop....
1
1307
by: CSN | last post by:
Are there any docs that deal with replication and Postgresql? Intro's, faq's, etc. Can anybody recommend a Postgresql replication package? I'm really not familiar with any - seems like there are several, with possibly Slony rising to the forefront. Are there any docs that compare the various options? Would there be any problems replicating data between
8
2783
by: sat | last post by:
Hi All! I have a small doubt in replication.Previously i was working on replication with the databases under the same instance.So it worked fine. Now i'm facing a new problem which is like, now i want the source db to be under one instance and target db to be under another instance. what i have done is i kept the source db(say sample) under same instance (say db2) as it was before.Now i created a new
13
6648
by: dancer | last post by:
I have made a new post because when I try to respond to another, I get the error, "Article Rejected -- Ill-formed message id" This is in response to the advice of Juan Libre to install Net Framework Service Pack 1 in order to use ASP.net 1.1 and the net Framework 1.1 ------------------------------------------------------------------------------------------------ I found the following file, "svcpack.log" at C:\WINNT. It contains many...
0
8761
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
8674
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9262
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
7876
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
6595
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
5923
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();...
1
3127
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2463
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2070
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.