Access 2007 I have linked sql table I cannot update; error says table read-only

Posted on 2011-05-04
Last Modified: 2012-05-11
Access 2007, SQL Express R2,  DAO

I have a linked Table from my WS2003 server's SQL database that when I try to Edit a record in the Table it throws an error:  "Cannot update.  Database or object is read-only., 3027"  

Not sure what I did to cause this to start happening, but I do not know how to advise that this Table is NOT read-only.  What may I have done to cause this?

Thanks for your help,
Question by:FrankBabz
    LVL 23

    Assisted Solution

    - this might related to OS level access rights issue.
    LVL 23

    Accepted Solution

    - set permissions to Read/Write/Execute in directory and database.
    - right click on the Access file and select "Properties". see that the "Read Only" attribute is not checked.
    - then go to the directory where your database is kept. right click on the folder name. at the "Sharing/Permissions" tab, and make sure the user account has Read/Write/Execute privilege.
    LVL 22

    Assisted Solution

    by:Nico Bontenbal
    Does the SQL table have a primary key?

    Author Comment

    Yes SQL table has/had an ID (autoincrement) column that appears to have gotten corrupted. In SMS I see (somehow) the autoincrement designation is gone (greyed out), and cannot be reinstated.  As I am able to read the data, I am currently working to create a new table and copy old data to it.  

    In Access I can right click on the Table and the properties do not include an attribute for "read only."  The only attribute it provides is a checkbox for Hidden.

    As all was working, I am 99% sure there is/are/were no permission problems.  I am administrator and full access rights everywhere on Workstation and Server.


    Author Closing Comment

    Am closing this out.   Never found out how Table was corrupted, but I was able to create a new table and copy old data to the new table.   New table is working fine.


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
    Article by: Leon
    Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now