Unable to delete records from Access Front-End!

[nsrw]

Please help!
My application comprises data housed on MSoft SQL server 7.0, and an Access2000 front-end. It's a straight-forward "flat" table, with a few lookup tables. When I try to delete/edit a record from the client-side I get an error "you and another user are attempting to change data at the same time....etc.".

However, when I access the table directly on the server, I can delete, edit, without any problem. Any suggestions from anyone?

Two: can someone tell me what equivalent is for a MEMO field, (Access) in a SQL 7.0 column? I need more than 255 char.

 

[Norris68]

Have you got a primary key defined on your tables? You can get into difficulties trying to update/delete if not.

The SQL equivalent of a memo field is 'text'