Database Sync

G

Guest

Guest
Archived from groups: microsoft.public.pocketpc (More info?)

I'm using a handheld database program to update a sync'ed copy of an Access
database. The app work fine and is allowing me to modify the copy of the db
on the handheld, however I cannot get it to sync it back to the laptop. Am
I missing something, is it supposed to happen automatically or do I have to
force the synchronisation

g
 
G

Guest

Guest
Archived from groups: microsoft.public.pocketpc (More info?)

If it is based on a PPC .cdb that is created and linked to a .mdb using
ActiveSync then it should sync automatically. That is given that it had all
the necessary pieces to do so when initially created. Mostly that requires a
definite unique key field as part of the sync'd data. Normally if the
conversion from a .mdb to .cdb is going to be one way only a warning to that
affect comes up when the link is first set up.

If the system you are using uses some other proprietary sync feature, I
can't help. What software are you using on the PPC?

--
Sven, MS-MVP Mobile Devices
"Gargamil" <wooble@tpgi.com.au> wrote in message
news:uqadZhAaEHA.4092@TK2MSFTNGP11.phx.gbl...
> I'm using a handheld database program to update a sync'ed copy of an
Access
> database. The app work fine and is allowing me to modify the copy of the
db
> on the handheld, however I cannot get it to sync it back to the laptop.
Am
> I missing something, is it supposed to happen automatically or do I have
to
> force the synchronisation
>
> g
>
>
 
G

Guest

Guest
Archived from groups: microsoft.public.pocketpc (More info?)

I'm using Win2002 and have noticed the sync seems to be going thru the
motions but to no avail. Once the data has been loaded to the PPC it won't
sync changes in either directions. I thought I set it up to sync when they
were loaded.
You mention a "definite unique key field"; the table I'm linking to has
five key fields required to uniquely identify records. Could something like
that be confusing it? I'm in the process of learning about CDB files. I've
been playing with Access since version 2 but have only had my PPC for about
a month.

g

"Sven, MVP-Mobile Devices" <sejohannsen@hotmail.com> wrote in message
news:%23LuRK3IaEHA.3804@TK2MSFTNGP10.phx.gbl...
> If it is based on a PPC .cdb that is created and linked to a .mdb using
> ActiveSync then it should sync automatically. That is given that it had
all
> the necessary pieces to do so when initially created. Mostly that requires
a
> definite unique key field as part of the sync'd data. Normally if the
> conversion from a .mdb to .cdb is going to be one way only a warning to
that
> affect comes up when the link is first set up.
>
> If the system you are using uses some other proprietary sync feature, I
> can't help. What software are you using on the PPC?
>
> --
> Sven, MS-MVP Mobile Devices
> "Gargamil" <wooble@tpgi.com.au> wrote in message
> news:uqadZhAaEHA.4092@TK2MSFTNGP11.phx.gbl...
> > I'm using a handheld database program to update a sync'ed copy of an
> Access
> > database. The app work fine and is allowing me to modify the copy of
the
> db
> > on the handheld, however I cannot get it to sync it back to the laptop.
> Am
> > I missing something, is it supposed to happen automatically or do I have
> to
> > force the synchronisation
> >
> > g
> >
> >
>
>
 
G

Guest

Guest
Archived from groups: microsoft.public.pocketpc (More info?)

By five key fields, do you mean that it takes a combination to identify a
unique record? You will need at least one field that the properties are set
to 'indexed-no duplicates' for the sync to be able to form a one-to-one
relationship between records. In other words one field with all unique
values in it. If you have none of these the easiest way to get one is to add
an index field and set it to autonumber. You don't have to use this for
anything else or even show it. You do have to include in the list of fields
that are going to be sync'd though. You did notice that you do not have to
include all the tables, or all the fields in all the tables, in the sync
definition, right?

There is a pretty good treatment of Access syncing at
http://www.biomobility.com/transfer.htm. It is geared towards DataOnThe Run
which is a pretty good .cdb viewer/massager, but it is primarily discussing
getting the .cdb right.



--
Sven, MS-MVP Mobile Devices
"Gargamil" <wooble@tpgi.com.au> wrote in message
news:uEZg%23gXaEHA.752@TK2MSFTNGP09.phx.gbl...
> I'm using Win2002 and have noticed the sync seems to be going thru the
> motions but to no avail. Once the data has been loaded to the PPC it
won't
> sync changes in either directions. I thought I set it up to sync when
they
> were loaded.
> You mention a "definite unique key field"; the table I'm linking to has
> five key fields required to uniquely identify records. Could something
like
> that be confusing it? I'm in the process of learning about CDB files.
I've
> been playing with Access since version 2 but have only had my PPC for
about
> a month.
>
> g
>
> "Sven, MVP-Mobile Devices" <sejohannsen@hotmail.com> wrote in message
> news:%23LuRK3IaEHA.3804@TK2MSFTNGP10.phx.gbl...
> > If it is based on a PPC .cdb that is created and linked to a .mdb using
> > ActiveSync then it should sync automatically. That is given that it had
> all
> > the necessary pieces to do so when initially created. Mostly that
requires
> a
> > definite unique key field as part of the sync'd data. Normally if the
> > conversion from a .mdb to .cdb is going to be one way only a warning to
> that
> > affect comes up when the link is first set up.
> >
> > If the system you are using uses some other proprietary sync feature, I
> > can't help. What software are you using on the PPC?
> >
> > --
> > Sven, MS-MVP Mobile Devices
> > "Gargamil" <wooble@tpgi.com.au> wrote in message
> > news:uqadZhAaEHA.4092@TK2MSFTNGP11.phx.gbl...
> > > I'm using a handheld database program to update a sync'ed copy of an
> > Access
> > > database. The app work fine and is allowing me to modify the copy of
> the
> > db
> > > on the handheld, however I cannot get it to sync it back to the
laptop.
> > Am
> > > I missing something, is it supposed to happen automatically or do I
have
> > to
> > > force the synchronisation
> > >
> > > g
> > >
> > >
> >
> >
>
>
 
G

Guest

Guest
Archived from groups: microsoft.public.pocketpc (More info?)

Correct. I'll try adding another Autonumber field to the table to uniquely
identify each record, and give it another run.

"Sven, MVP-Mobile Devices" <sejohannsen@hotmail.com> wrote in message
news:eY0kbqfaEHA.2408@tk2msftngp13.phx.gbl...
> By five key fields, do you mean that it takes a combination to identify a
> unique record? You will need at least one field that the properties are
set
> to 'indexed-no duplicates' for the sync to be able to form a one-to-one
> relationship between records. In other words one field with all unique
> values in it. If you have none of these the easiest way to get one is to
add
> an index field and set it to autonumber. You don't have to use this for
> anything else or even show it. You do have to include in the list of
fields
> that are going to be sync'd though. You did notice that you do not have to
> include all the tables, or all the fields in all the tables, in the sync
> definition, right?
>
> There is a pretty good treatment of Access syncing at
> http://www.biomobility.com/transfer.htm. It is geared towards DataOnThe
Run
> which is a pretty good .cdb viewer/massager, but it is primarily
discussing
> getting the .cdb right.
>
>
>
> --
> Sven, MS-MVP Mobile Devices
> "Gargamil" <wooble@tpgi.com.au> wrote in message
> news:uEZg%23gXaEHA.752@TK2MSFTNGP09.phx.gbl...
> > I'm using Win2002 and have noticed the sync seems to be going thru the
> > motions but to no avail. Once the data has been loaded to the PPC it
> won't
> > sync changes in either directions. I thought I set it up to sync when
> they
> > were loaded.
> > You mention a "definite unique key field"; the table I'm linking to has
> > five key fields required to uniquely identify records. Could something
> like
> > that be confusing it? I'm in the process of learning about CDB files.
> I've
> > been playing with Access since version 2 but have only had my PPC for
> about
> > a month.
> >
> > g
> >
> > "Sven, MVP-Mobile Devices" <sejohannsen@hotmail.com> wrote in message
> > news:%23LuRK3IaEHA.3804@TK2MSFTNGP10.phx.gbl...
> > > If it is based on a PPC .cdb that is created and linked to a .mdb
using
> > > ActiveSync then it should sync automatically. That is given that it
had
> > all
> > > the necessary pieces to do so when initially created. Mostly that
> requires
> > a
> > > definite unique key field as part of the sync'd data. Normally if the
> > > conversion from a .mdb to .cdb is going to be one way only a warning
to
> > that
> > > affect comes up when the link is first set up.
> > >
> > > If the system you are using uses some other proprietary sync feature,
I
> > > can't help. What software are you using on the PPC?
> > >
> > > --
> > > Sven, MS-MVP Mobile Devices
> > > "Gargamil" <wooble@tpgi.com.au> wrote in message
> > > news:uqadZhAaEHA.4092@TK2MSFTNGP11.phx.gbl...
> > > > I'm using a handheld database program to update a sync'ed copy of an
> > > Access
> > > > database. The app work fine and is allowing me to modify the copy
of
> > the
> > > db
> > > > on the handheld, however I cannot get it to sync it back to the
> laptop.
> > > Am
> > > > I missing something, is it supposed to happen automatically or do I
> have
> > > to
> > > > force the synchronisation
> > > >
> > > > g
> > > >
> > > >
> > >
> > >
> >
> >
>
>
 
G

Guest

Guest
Archived from groups: microsoft.public.pocketpc (More info?)

As a continuance of this theme, I get this error when syncing one of the
table in my app.

Synchronizing table tblEquipmentHistory. One or more arguments are
invalid

An unexpected error occurred when finding changed rows in the table
tblEquipmentHistory. This table will not be synchronized.

Anyone recognise it? Any ideas on what going wrong??

g

"Gargamil" <wooble@tpgi.com.au> wrote in message
news:OK8xQXtaEHA.2408@tk2msftngp13.phx.gbl...
> Correct. I'll try adding another Autonumber field to the table to
uniquely
> identify each record, and give it another run.
>
> "Sven, MVP-Mobile Devices" <sejohannsen@hotmail.com> wrote in message
> news:eY0kbqfaEHA.2408@tk2msftngp13.phx.gbl...
> > By five key fields, do you mean that it takes a combination to identify
a
> > unique record? You will need at least one field that the properties are
> set
> > to 'indexed-no duplicates' for the sync to be able to form a one-to-one
> > relationship between records. In other words one field with all unique
> > values in it. If you have none of these the easiest way to get one is to
> add
> > an index field and set it to autonumber. You don't have to use this for
> > anything else or even show it. You do have to include in the list of
> fields
> > that are going to be sync'd though. You did notice that you do not have
to
> > include all the tables, or all the fields in all the tables, in the sync
> > definition, right?
> >
> > There is a pretty good treatment of Access syncing at
> > http://www.biomobility.com/transfer.htm. It is geared towards DataOnThe
> Run
> > which is a pretty good .cdb viewer/massager, but it is primarily
> discussing
> > getting the .cdb right.
> >
> >
> >
> > --
> > Sven, MS-MVP Mobile Devices
> > "Gargamil" <wooble@tpgi.com.au> wrote in message
> > news:uEZg%23gXaEHA.752@TK2MSFTNGP09.phx.gbl...
> > > I'm using Win2002 and have noticed the sync seems to be going thru the
> > > motions but to no avail. Once the data has been loaded to the PPC it
> > won't
> > > sync changes in either directions. I thought I set it up to sync when
> > they
> > > were loaded.
> > > You mention a "definite unique key field"; the table I'm linking to
has
> > > five key fields required to uniquely identify records. Could
something
> > like
> > > that be confusing it? I'm in the process of learning about CDB files.
> > I've
> > > been playing with Access since version 2 but have only had my PPC for
> > about
> > > a month.
> > >
> > > g
> > >
> > > "Sven, MVP-Mobile Devices" <sejohannsen@hotmail.com> wrote in message
> > > news:%23LuRK3IaEHA.3804@TK2MSFTNGP10.phx.gbl...
> > > > If it is based on a PPC .cdb that is created and linked to a .mdb
> using
> > > > ActiveSync then it should sync automatically. That is given that it
> had
> > > all
> > > > the necessary pieces to do so when initially created. Mostly that
> > requires
> > > a
> > > > definite unique key field as part of the sync'd data. Normally if
the
> > > > conversion from a .mdb to .cdb is going to be one way only a warning
> to
> > > that
> > > > affect comes up when the link is first set up.
> > > >
> > > > If the system you are using uses some other proprietary sync
feature,
> I
> > > > can't help. What software are you using on the PPC?
> > > >
> > > > --
> > > > Sven, MS-MVP Mobile Devices
> > > > "Gargamil" <wooble@tpgi.com.au> wrote in message
> > > > news:uqadZhAaEHA.4092@TK2MSFTNGP11.phx.gbl...
> > > > > I'm using a handheld database program to update a sync'ed copy of
an
> > > > Access
> > > > > database. The app work fine and is allowing me to modify the copy
> of
> > > the
> > > > db
> > > > > on the handheld, however I cannot get it to sync it back to the
> > laptop.
> > > > Am
> > > > > I missing something, is it supposed to happen automatically or do
I
> > have
> > > > to
> > > > > force the synchronisation
> > > > >
> > > > > g
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>