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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 342
  • Last Modified:

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

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
Anandhi1
Asked:
Anandhi1
  • 3
  • 2
  • 2
1 Solution
 
DiveblueCommented:
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
 
jmoss111Commented:
Do the linked tables have time stamps?
0
 
Anandhi1Author Commented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
jmoss111Commented:
You'll need primary key and/or timestamp.
0
 
Anandhi1Author Commented:
So do i need column with timestamp datatype in the table?
0
 
DiveblueCommented:
you should not need timestamp so long as the table has a pk defined
0
 
DiveblueCommented:
if you open the table directly in access(not using the form), can you edit it?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now