Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2011-05-04
Medium Priority
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
  • 2
  • 2
LVL 23

Assisted Solution

OP_Zaharin earned 999 total points
ID: 35695594
- this might related to OS level access rights issue.
LVL 23

Accepted Solution

OP_Zaharin earned 999 total points
ID: 35695614
- 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
Nico Bontenbal earned 501 total points
ID: 35696206
Does the SQL table have a primary key?

Author Comment

ID: 35698745
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

ID: 35738299
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

578 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