simple query question

[c0dec]

Probably a simple one!

I have written a simple query with 4 linked tables. 2 of these being brought in from a read-only ODBC link and the other 2 from tables.

My question is simple, basicly I have a field in one of my tables called "Qty" I need to be able to edit this field from my query and at the moment this is not possible. As soon as I add any linked tables the query is unable to write to the table.

We have other querys that can write to tables ok which are also using read-only ODBC linked tables so this leaves me a little confused.

Any help would be great.

Regards
Dan

 

[Remou]

Have any of these tables a unique index?

You may find notes here:
Harnessing the Power of Updatable Queries

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_harness.asp

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886