Update a linked table via a query

D

Dave

I want to use a Table in MS ACCESS (Employees) to update a linked FoxPro
Table (Employees Data).

I have the link table working just fine, but I don't know how to update that
table.

I what to bounce the (employees) table against the (employees data) table so
that the old (employee data) in deleted in the linked table.

I know that I can do this by creating a new table, but I want the current
(employee data) table to be updated without creating new tables.

Is there a way to do this?

Thanks
 
Top