Access 2002 Update Query on link Fox 2.6 table

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing FoxPro 2.6 DBF Into Access 2007 1
Access import from Excel - Append & Update simultaneously 1
Linking to Foxpro 2.6 datatable 2
Linking to Foxpro 2.6 3
Insert query 0
Using Append Queries with Linked Tables 3
Can't use ODBC-link from Access 2007 to Visual Fox pro (.dbf) 2
How do I find the indices on a table in Access 2003? 4

Top