Not Updatable Table?

[EddyLLC]

I have a table that I added a auto counter field to and made it the primary key. Now when I go to the form that accesses the table via a query I can not update any of the data. None of the fields can be changed. Does this have something to do with the counter field? Is there a way to prevent this?

Thanks

 

[PHV]

Does the query include this primary key ?

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

 

[EddyLLC]

Yes it does include the counter field but there is no link between it and any other field in the other tables in the query.

 

[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