on my laptop, i have an access front end with tables linking to sql server personal edition.

i open a linked table, edit a field, and i get a write conflict error message 'this record has been changed by another user since you edited it', and the save record button is not enabled

i have many linked tables, but this is the only table that gives me this error. i have deleted the table in sql server, and made a new table, and started the link process again, but still the write conflict.

also, as i dont know if this is related.

when i get tothe screen to link the tables, i see 2 table names prefixed with a "~", however, when i go into sql server, i cannot see any tables prefixed with a "~"

any responses would be most appreciative, as my project has effectively stopped until i can resolve this.

Usually a deleted object [table] is prefixed with the ~. Try running the repair and compact functions on your db to remove the old junk from your system tables. Just because you delete something does not make it go away in Access [until you compact the db]. Which is why Access db's bloat very easily.