Read Only Table in Access 1

[Smithsc]

Hi,
I'm not sure if this is the correct Forum for this problem so appologies if I've got it wrong.

I've got a access db which contains a linked table (via ODBC) to an SQL db. I need to be able to delete the records on this table from access but every time I try it tells me the data is read only. I've checked the table permissions on the SQL side and they all allow me to delete records.

What am I doing wrong.

Many thanks for any help.

 

[Remou]

Do you have a primary key?

http://bytes.com/forum/thread662474.html

 

[PHV]

In fact, does Access recognize a PK ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Smithsc]

There are no primary keys or indexes on this table.

 

[Remou]

You need one, if you want to make changes to the table. You should be asked for a pk when you link the table.

 

[Smithsc]

I thought is was something simple. It worked.

Many thanks remou