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
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Facebook
Twitter