Unable to Update Sharepoint list from MS Access

[Dean]

I have linked some WSS 2.0 lists to an Access 2003 mdb. I can open the
linked tables and manually update the data without any problem. However, I
want to update the WSS list from an Access query but I keep getting an
Operation Must Use an Updatable Query error message. I have tried updaing
just one field and still get the same error. Any ideas on how I can
troubleshoot.

TIA
Dean

 

[Tom Wickerath MDB]

I would reccomend not using SharePoint linked tables

seriously-- it's too buggy for real world usage

 

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.