Access 2002 Update Query on link Fox 2.6 table

  • Thread starter Thread starter Colin Foxton
  • Start date Start date
C

Colin Foxton

It used to work in Access97 but not in 2002.

I could update a Fox 2.6 dbf with no problem but with the ODBC driver
6.01.8629.01 I can't.

If I link the table without a primary key update says it needs a primary
key, If I use a primary key it won't update because of

'Single row update/delete affected more than one row of a linked table.
Unique index contains duplicate values.'

Problem is I don't have a field that doesn't have duplicate values.

Any answers.

Thanks

Colin
 
Back
Top