C
Chris
I want to synchronise a table in acces with a linked
extrernal table (Foxpro). Because the linked table is
Foxpro I'm not able to make a promary key. One field in
both tables have equal data. There are two possibilities:
One: there are more (new) records in the linked table than
in the access table
Two: there are less (deleted) records in the linked table
than in the acces table
For one I can use an append query, this works fine. For
two I can make a query that gives the records that have to
be deleted in the access database but I can't find a
standard access function to delete these records. I would
think the delete Query would be able to do this but that
doesn't work. I get a errormessage saying 'couldn't delete
from specified tables'
Does anybody have any suggestion? If it's possible i would
like to avoid using VBA / SQL scripting
thanks in advance
extrernal table (Foxpro). Because the linked table is
Foxpro I'm not able to make a promary key. One field in
both tables have equal data. There are two possibilities:
One: there are more (new) records in the linked table than
in the access table
Two: there are less (deleted) records in the linked table
than in the acces table
For one I can use an append query, this works fine. For
two I can make a query that gives the records that have to
be deleted in the access database but I can't find a
standard access function to delete these records. I would
think the delete Query would be able to do this but that
doesn't work. I get a errormessage saying 'couldn't delete
from specified tables'
Does anybody have any suggestion? If it's possible i would
like to avoid using VBA / SQL scripting
thanks in advance