Pocket Access sync problems with pc replica

Pocket Access sync problems with pc replica

Post by bret » Fri, 23 Dec 2005 10:20:20


Hi there,

I want to be able to use some software to synchronize
a MS Access database between a pc and several Pocket
PC PDA's. Each PDA will have a replica of the database on it.

I have wrote a front end for the database on the pc
and on the PDA's ( each PDA is running windows mobile
2003)

What I need is sync software that will sync all the
changes on either device (the pc and the pocket PC),
so everything including additions, updates and deletes
are synchronized between the two databases in
question.

I need to be able to set what tables sync in what
order so there are no referential issues.

Also having one global conduit, or a group conduit
would be a distinct advantage.

The order of which tables synchronize first etc cannot
be altered with MS Active sync, which I have been using
so far. This is where I have had a problem and we have
decided to look for a third party synchronization solution.

I can write code to get around the problems Active Sync has, handling
replication errors etc. But since this databases has 18 tables, and
access is the only db available to me. (I work in a hospital, mysql,
oracle, sql server and others are out) To write this code, seems like
to much work to get round something that I feel ms should have
included with active sync, the ability to set the order which tables
sync.

Plus each PDA has to have its own conduit, and active sync is very
flakey regarding conduit's and syncing at times.

So my question is this, do and of you guys know of any synchronization
software that meets these requirements?

Thank you for taking the time to read this post

Kind Regards

Brett Halligan
Systems Developer
Southport and District general hospital
England
 
 
 

Pocket Access sync problems with pc replica

Post by David W. F » Fri, 23 Dec 2005 12:08:21

brett < XXXX@XXXXX.COM > wrote in



Pocket Access and Microsoft Access have nothing to do with each
other, and Jet replication has nothing to do with Pocket Access. So
far as I know, Jet is not even used by Pocket Access.

Indeed, I don't really think Pocket Access is a very good choice, as
it appears to me that MS has abandoned it -- it's almost impossible
to find information about it.

The WinCE version of SQL would be an alternative, but I don't know
what state it's in, either, nor what techniques are available for
synchronizing. If I'm mistaken, it's not really SQL Server, either,
but I could be wrong.

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

 
 
 

Pocket Access sync problems with pc replica

Post by bret » Fri, 23 Dec 2005 12:42:03

On Wed, 21 Dec 2005 21:08:21 -0600, "David W. Fenton"




thank you for your reply

Pocket access does have very little support but this is all I can use
due to restrictions with the national health system and what tech
support will allow on the server etc.

Pocket Access is still supported in the latest version 3.8 of MS
Active sync.

A Pocket Access DB is just a copy of a MS Access DB with 0 forms and
reports.

Some documentation for it comes with Embed VB 3 for PDA's But it is
lacking in detail.

MS say they dont provide a front end to it anymore because they leave
it open to third party developers to develope software for it,
probably a lie or excuse because they dont wana support it ne more.

Any one else know of any sync software that supports other databases
that I could propose to tech support for consideration?

Thanks in advance

Brett
 
 
 

Pocket Access sync problems with pc replica

Post by David W. F » Sat, 24 Dec 2005 05:52:50

brett < XXXX@XXXXX.COM > wrote in



I searched the MS website and just couldn't find anything at all
that said anything useful about your problems.


In other words, a pure Jet database.

That means it *could* be replicated, but my bet is that the synch
happens by copying the db file back and forth, which would badly
break replication, of course.


Well, this topic has been discussed in comp.databases.ms-access
several times, though not always limited to PocketPC (personally,
I'd prefer a Palm-based solution, just to keep variety in the
software ecosystem).

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

Pocket Access sync problems with pc replica

Post by calafradul » Tue, 27 Dec 2005 20:18:51


Why not just copy the replicated DB from the PDA to a PC then synch it on a
the PC? IT would be easy enough to write a UI into the solution to copy the
file back and forth. Why bother with the handheld device for the synching?
Wasn't briefcase was available on PDA's.
 
 
 

Pocket Access sync problems with pc replica

Post by David W. F » Wed, 28 Dec 2005 05:10:42

"calafradulistic" < XXXX@XXXXX.COM > wrote in



Because this violates all the rules of how Jet replication works.
The result is that you'd end up with lots of dead replicas and
eventually this would completely hose your replica set and leave you
with an inability to synchronize at all.


You can't copy replicated databases through the file system if you
intend to synchronize with them after the copy. Jet synchronization
is designed to be done IN PLACE.

Search the Google Groups archives for this newsgroup for "dead
replica" to see why copying files simply can never work with Jet
replication.

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

Pocket Access sync problems with pc replica

Post by bret » Sat, 07 Jan 2006 12:19:31

On Thu, 22 Dec 2005 14:52:50 -0600, "David W. Fenton"




Thanks for your reply
I think I will just have to write code round these issues, as it
cannot be restarted now, it is to late in the development process
Brett