Post reply

Using MS access to edit SQL Server tables

  • August 26, 2003 at 1:25 pm

    #82408

    I am totally stumped as to why this problem exits. I have given total read/write/edit/delete to the user and yet when the SQL Server table is open in MS Access the user gets an error message that says the table is read only. That is absolutely not case for both NT authentication as well as using the account that is the table owner. Has anyone seen such odd behavior before? I have absolutely no other ideas to try.

  • August 26, 2003 at 9:38 pm

    #471524

    Can you post the completed error message?

  • August 27, 2003 at 3:08 am

    #471558

    Have you got a primary key on the table? The table will be read only if there is no primary key. Also once you have created a primary key you need to refresh or recreate the link.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply