Solved

link table in Access database is locked.  I can not edit the table.

Posted on 2008-10-30
7
306 Views
Last Modified: 2013-11-29
I have database created in SQL server 2005 and linked tables in Access database.  I can view all the link tables in access database but i can not edit any tables.  If i edit table in SQL Server then i can see the changes in Access link table.  

I want to be able to make changes from Access tabes.  I have form that is using lunked table to edit information. I can pull up information in the form but can not make any changes.

I know it is possibel i just cant remember how to do it.

Thank you in advance.
0
Comment
Question by:Anandhi1
  • 3
  • 2
  • 2
7 Comments
 
LVL 3

Expert Comment

by:Diveblue
ID: 22842015
are you using sql server authentication or windows authentication (Do you log into sql server with a uid/pwd) ?

does the account you are using to link the access tables have edit authority on the tables?

do the tables have primary keys defined?
0
 
LVL 18

Expert Comment

by:jmoss111
ID: 22842287
Do the linked tables have time stamps?
0
 
LVL 1

Author Comment

by:Anandhi1
ID: 22842568
I'm using SQL Server Authentication and it has dbo privileges.  I created ODBC DSN and used that loging to link in Access database.

Yes.  Some tables have primary key and foriegn key.

I didnt see time stpamp field in tables.

Thank You.
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 18

Expert Comment

by:jmoss111
ID: 22842658
You'll need primary key and/or timestamp.
0
 
LVL 1

Author Comment

by:Anandhi1
ID: 22843385
So do i need column with timestamp datatype in the table?
0
 
LVL 3

Accepted Solution

by:
Diveblue earned 500 total points
ID: 22845400
you should not need timestamp so long as the table has a pk defined
0
 
LVL 3

Expert Comment

by:Diveblue
ID: 22845409
if you open the table directly in access(not using the form), can you edit it?
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

772 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