Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / February 2007

Tip: Looking for answers? Try searching our database.

Vista Synchronization

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RB - 12 Feb 2007 17:43 GMT
When we attempt to Internet sync on any computer using Vista, we get this
error:
---------------------------------
Microsft Visual C++Runtime Library X Assertion failed!
Program:...
File z:\COMMON\inc\safestrfuncs.h
Line:108
Expression:s_OK= = hr
For information on how your program can cause an assertion failure, se the
visual C ++ documentation on asserts (Please retry to debug  the application
JIT must be enabled)

ABORT   RETRY   IGNORE
-------------------------

How can we resolve this?

Thanks in advance:
David W. Fenton - 13 Feb 2007 00:33 GMT
> When we attempt to Internet sync on any computer using Vista, we
> get this error:
[quoted text clipped - 14 lines]
>
> Thanks in advance:

Are you using DAO or JRO for this? What version of Access?

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

RB - 13 Feb 2007 02:00 GMT
David:

We are using DAO, Access 2000.  JRO gave us problems with deployment to our
more than a thousand users.

We have granted rights to our application and the data set but suspect that
the Jet Synchronizer has a file that is violating the UAC (user account
control)?

A JRO utility could be used for a temporary solution.

Thank you and I look forward to your response.

RB

>> When we attempt to Internet sync on any computer using Vista, we
>> get this error:
[quoted text clipped - 16 lines]
>
> Are you using DAO or JRO for this? What version of Access?
David W. Fenton - 13 Feb 2007 19:18 GMT
>>> When we attempt to Internet sync on any computer using Vista, we
>>> get this error:
[quoted text clipped - 19 lines]
> We are using DAO, Access 2000.  JRO gave us problems with
> deployment to our more than a thousand users.

I'm not fan of JRO, myself. I do know that DAO is broken in A2K7,
and perhaps the reason is the same as the problem you're hitting
running on Vista.

> We have granted rights to our application and the data set but
> suspect that the Jet Synchronizer has a file that is violating the
> UAC (user account control)?

The synchronizer doesn't write any data except to the dropbox and to
the location of any unmanaged replica that you try to synch with.

> A JRO utility could be used for a temporary solution.
>
> Thank you and I look forward to your response.

I don't do Internet replication, to be honest (I don't see its
utility any longer with VPNs so common), so can't give you specific
advice. All that I've written above somewhat assumes that the
Internet synchrnizer works more or less the same as the indirect
synchronizer, which may be completely wrong.

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

RB - 14 Feb 2007 20:00 GMT
David:

Thank you for your replies, we're going to try the JRO method, and I'll post
the result.

With hundreds of unrelated users, Internet synchronization avoids VPN
security and support related issues.  If a VPN connection is interrupted,
the replica being synchronized to is frequently corrupted and had to be
replaced.  The transaction basis of the Internet synchronization gives us
more reliable results.

RB

>>>> When we attempt to Internet sync on any computer using Vista, we
>>>> get this error:
[quoted text clipped - 40 lines]
> Internet synchrnizer works more or less the same as the indirect
> synchronizer, which may be completely wrong.
David W. Fenton - 16 Feb 2007 01:21 GMT
> With hundreds of unrelated users, Internet synchronization avoids
> VPN security and support related issues.  If a VPN connection is
> interrupted, the replica being synchronized to is frequently
> corrupted and had to be replaced.  

Not if you you use indirect replication. I was not at all suggesting
DIRECT replication over a VPN over the Internet!

The transaction basis of the Internet synchronization gives us
> more reliable results.

But Internet replication brings a dependency on IIS, and I consider
that unacceptable (because IIS is unacceptable, and because Jet
replication doesn't need any more dependencies than it already has).
Indirect replication works just fine over a VPN and it matters not
one bit whether or not the VPN goes down during the synch, as all
that will be lost is the files dropped in the synchronizer dropboxes
(just like with Internet replication).

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

RB - 17 Feb 2007 22:28 GMT
David:

Unfortunately, the JRO Internet synchronization reports the same error as
ADO on the Vista OS.

Boo hiss.

>> With hundreds of unrelated users, Internet synchronization avoids
>> VPN security and support related issues.  If a VPN connection is
[quoted text clipped - 14 lines]
> that will be lost is the files dropped in the synchronizer dropboxes
> (just like with Internet replication).
David W. Fenton - 18 Feb 2007 03:23 GMT
> Unfortunately, the JRO Internet synchronization reports the same
> error as ADO on the Vista OS.

What version of Access are you using here? Do you have the latest
Jet Replication update files?

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

RB - 22 Feb 2007 20:42 GMT
David:

Access 2K latest updates, SR1, SR3, and sp8.  The clients may not.  That is
certainly worth a try.  I'll post the results.

Thanks,

Robert

>> Unfortunately, the JRO Internet synchronization reports the same
>> error as ADO on the Vista OS.
>
> What version of Access are you using here? Do you have the latest
> Jet Replication update files?
David W. Fenton - 22 Feb 2007 21:09 GMT
>>> Unfortunately, the JRO Internet synchronization reports the same
>>> error as ADO on the Vista OS.
[quoted text clipped - 4 lines]
> Access 2K latest updates, SR1, SR3, and sp8.  The clients may not.
>  That is certainly worth a try.  I'll post the results.

But what about the replication files? Those are not part of Access
or Jet, so don't get updated -- only the Jet Replication Security
update does that.

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

RB - 22 Feb 2007 21:50 GMT
Thanks, I'll try that out.

>>>> Unfortunately, the JRO Internet synchronization reports the same
>>>> error as ADO on the Vista OS.
[quoted text clipped - 8 lines]
> or Jet, so don't get updated -- only the Jet Replication Security
> update does that.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.