Tables Read Only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Humberto Alvarez - 25 May 2005 19:37 GMT

Access 2003 Win 2k

I have a table that I need to add and delete records to. However there is
an error message that tells me that the table is read only. Also the new
record feild doesn not appear.

Thanks For the help

Humberto

Reply to this Message

Alex White MCDBA MCSE - 25 May 2005 19:51 GMT

sounds like no primary key is setup on the table.

Signature

Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

> Access 2003 Win 2k
>
[quoted text clipped - 5 lines]
>
> Humberto

Reply to this Message

Humberto Alvarez - 25 May 2005 21:23 GMT

The problem occurs when I select a field in the datasheet view and I ask to
sort ascending or descending. I went to the table properties in design view
and I removed the text inside "order by" and now I can modify the table
again.

However I don't understand why this happens. Does someone know the reason?

Thanks,
Humberto

> sounds like no primary key is setup on the table.
>
[quoted text clipped - 7 lines]
> >
> > Humberto

Reply to this Message