Solved

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

Posted on 2008-10-30
7
319 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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.

761 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