Much thanks,
As i understoot it do not imposible update recordset without table linking.
""Greg Campbell"" <greg.campbell@us.michelin.com> wrote in message
news:42A842B5.9050100@us.michelin.com...
> If your recordset is going to be not updateable,
> you should try a dbOpenReadOnly instead of dbOpenDynaset.
> In fact I would say dbOpenDynaset should be reserved for Jet datasources.
> Make DML updates using individual UPDATE, INSERT, and DELETE statements.
>> I can edit link'ed table. Primary key exists too. But
>> Set recordset = conODBC.OpenRecordset("SELECT * FROM table",
>> dbOpenDynaset
>> [,dbOptimistic] )
>> recordset.updatable = false
>> what is wrong?