Right, further to previous question not so long ago...
I have a fairly complex access database that has a number of linked
tables in it. The main table of this database is a details one that has
a large number of fields in it that I have mapped to a HanDBase table on
my PDA.
I've got my two databases mapping the data in the appropriate fields on
each table. The only problem is that because the tables in the Access
file are linked to a number of different tables within the same database
it causes errors in the 'syncronisation'.
I can change things on the Access database and it will change (when
synchronised) the HanDBase file on the PDA. I can add new records to the
table on the PDA and this will be added to the Access DB but when I try
to change a field on a current record it won't work.
The error it brings up in the log file is:
"- Error was [Microsoft][ODBC Microsoft Access Driver] The record cannot
be deleted or changed because table 'cub/camp link' includes related
records."
I know there has to be someway around this problem with a little bit of
coding - perhaps mapping the changs to a temporary table before copying
it over to the actual table. The problem I see is that each record has a
Primary key that I use to link all the data in individual tables, as
such I need to keep the primary key when I update/change data.
I also think it's worth pointing out that I am not all that good when it
comes to coding and scripts - so simple terms would be appreciated!
Cheers!
--
Chris Naylor
Remove your trousers to reply
http://www.neff.org.uk
http://www.ireland2006eb.org.uk/
If one synchronized swimmer drowns, do the rest have to drown too?