can't save record

[yuchieh]

I have an Access (XP) database with multiple tables linked from SQL Server2000. In Access, I cannot save edited data in some tables (but not all tables; in some I could.) I don't see any "lock" sign in the records, nor is there another user accessing the database/tables the same time. I am pizzled. Any ideas?

Thanks.

 

[Tranman]

Are any of your tables possibly views instead of tables? Updating linked SQL views can be a real problem, and impossible if you create links external to the SQL server.

 

[yuchieh]

nope, all of them are main tables from SQL.

 

[JonFer]

I assume you have permission to update all of the tables. Does each table have a primary key? I have had problems trying to update data in a linked table without a unique/primary index assigned.

 

[yuchieh]

found the problem.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;280730

just need to add a timestamp field to the tables with bit values