Solved

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

Posted on 2008-10-30
7
292 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

932 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