|
 |
access thread: Automatic Replication under Windows NT
Message #1 by "David W Faries" <David.W.Faries@U...> on Fri, 22 Mar 2002 16:41:03 -0500
|
|
The Scenario:
A computer in a laboratory runs a vendor's proprietary software controlling
a labratory instrument. Test Methods (which control the instrument
operation) and test results are stored in Access97 databases on the local
hard drive. The operating system on this machine is NT 4.0
Copies of these databases reside on a network file server in an NT Domain.
When the instrument is used, the operator logs into the NT domain through
the instrument control computer.
New Test Methods might be entered into either the Instrument Computer
database, or the server database.
My client wants to have an automatic backup & synchronization of the
databases each evening. Note that synchronization is the key, as there
could be Test Methods moving in both directions during the operation.
At the time this operation runs over night, there will be no user logged
into the domain (or the local computer for that matter).
I can not run whatever "agent" is going to make this happen on the server
side, it will have to be initiated on the local instrument computer side.
This seems to indicate that this "synchronization agent" would have to run
as an NT service, since there is no user account available to run it in at
night.
I have tried converting a Microsoft Jet Synchronizer to run as an NT
service with some 3rd party "run-it-as-a-service" tools. I have had no
success with this approach. Any time a user does log in, another
Synchronizer starts up, which stalls the whole Replication Manager. Even
without a user logging in, the Replication Manager does not recognize the
"service-ized" Synchronizer.
I do believe I have the ability to write a totally custom solution in VB,
but I would REALLY like to find a simpler solution. An off-the-shelf
product that would do this would be lovely. Failing that, advice on
developing the custom application would be OK too.
Any help and suggestions greatly appreciated.
Regards,
Dave
Message #2 by "Richard Berry" <Richard@D...> on Sat, 23 Mar 2002 08:33:25 -0000
|
|
Dave,
How about using the Microsoft Replication manager in the developer kit.
Regards
Richard Berry
Desktop Logic Limited
Crowland
Peterborough
PE6 0AG
Tel: 08707 486486
Fax: 08707 486487
Email: Richard@D...
-----Original Message-----
From: David W Faries [mailto:David.W.Faries@U...]
Sent: 22 March 2002 21:41
To: Access
Subject: [access] Automatic Replication under Windows NT
The Scenario:
A computer in a laboratory runs a vendor's proprietary software controlling
a labratory instrument. Test Methods (which control the instrument
operation) and test results are stored in Access97 databases on the local
hard drive. The operating system on this machine is NT 4.0
Copies of these databases reside on a network file server in an NT Domain.
When the instrument is used, the operator logs into the NT domain through
the instrument control computer.
New Test Methods might be entered into either the Instrument Computer
database, or the server database.
My client wants to have an automatic backup & synchronization of the
databases each evening. Note that synchronization is the key, as there
could be Test Methods moving in both directions during the operation.
At the time this operation runs over night, there will be no user logged
into the domain (or the local computer for that matter).
I can not run whatever "agent" is going to make this happen on the server
side, it will have to be initiated on the local instrument computer side.
This seems to indicate that this "synchronization agent" would have to run
as an NT service, since there is no user account available to run it in at
night.
I have tried converting a Microsoft Jet Synchronizer to run as an NT
service with some 3rd party "run-it-as-a-service" tools. I have had no
success with this approach. Any time a user does log in, another
Synchronizer starts up, which stalls the whole Replication Manager. Even
without a user logging in, the Replication Manager does not recognize the
"service-ized" Synchronizer.
I do believe I have the ability to write a totally custom solution in VB,
but I would REALLY like to find a simpler solution. An off-the-shelf
product that would do this would be lovely. Failing that, advice on
developing the custom application would be OK too.
Any help and suggestions greatly appreciated.
Regards,
Dave
Message #3 by "Haslett, Andrew" <andrew.haslett@i...> on Tue, 26 Mar 2002 08:59:35 +1030
|
|
Michael Kaplan over at Trigeminal software has a number of 'replication'
utilities available.
http://www.trigeminal.com/index.asp?1033
Cheers,
Andrew
-----Original Message-----
From: Richard Berry [mailto:Richard@D...]
Sent: Saturday, 23 March 2002 7:03 PM
To: Access
Subject: [access] RE: Automatic Replication under Windows NT
Dave,
How about using the Microsoft Replication manager in the developer kit.
Regards
Richard Berry
Desktop Logic Limited
Crowland
Peterborough
PE6 0AG
Tel: 08707 486486
Fax: 08707 486487
Email: Richard@D...
-----Original Message-----
From: David W Faries [mailto:David.W.Faries@U...]
Sent: 22 March 2002 21:41
To: Access
Subject: [access] Automatic Replication under Windows NT
The Scenario:
A computer in a laboratory runs a vendor's proprietary software controlling
a labratory instrument. Test Methods (which control the instrument
operation) and test results are stored in Access97 databases on the local
hard drive. The operating system on this machine is NT 4.0
Copies of these databases reside on a network file server in an NT Domain.
When the instrument is used, the operator logs into the NT domain through
the instrument control computer.
New Test Methods might be entered into either the Instrument Computer
database, or the server database.
My client wants to have an automatic backup & synchronization of the
databases each evening. Note that synchronization is the key, as there
could be Test Methods moving in both directions during the operation.
At the time this operation runs over night, there will be no user logged
into the domain (or the local computer for that matter).
I can not run whatever "agent" is going to make this happen on the server
side, it will have to be initiated on the local instrument computer side.
This seems to indicate that this "synchronization agent" would have to run
as an NT service, since there is no user account available to run it in at
night.
I have tried converting a Microsoft Jet Synchronizer to run as an NT
service with some 3rd party "run-it-as-a-service" tools. I have had no
success with this approach. Any time a user does log in, another
Synchronizer starts up, which stalls the whole Replication Manager. Even
without a user logging in, the Replication Manager does not recognize the
"service-ized" Synchronizer.
I do believe I have the ability to write a totally custom solution in VB,
but I would REALLY like to find a simpler solution. An off-the-shelf
product that would do this would be lovely. Failing that, advice on
developing the custom application would be OK too.
Any help and suggestions greatly appreciated.
Regards,
Dave
|
|
|
View Cart
