Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Why linked table is read only? 1

Status
Not open for further replies.
hu68

hu68

Technical User
Feb 19, 2002
30
0
0
CA
hi ,there
In my access database , I have two linked table. T1 linked with another access database,T2 linked with SQL database.
T1 is fine ,I can insert or update data.but I can't modify data in T2.I have no idea why T2 is read only? I check T2's permission in SQL,public user hava full permission to it.Could anyone tell me how to make T2 writable?
Thanks in advance.

Hu
 
Sort by date Sort by votes
One thing to check on the sql server table is that it has an unique primary key. Access cannot update without a unique key.
 
Upvote 0 Downvote
Hi.cmmrfrds
Thanks for your suggestion,I check the table found it lost primary key.I put it there.It's fixed.
Thanks lot

Hu
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

raywood1
  • Locked
  • Question
Reducing a Massive Linked Table
Replies
4
Views
108
dhookom
dhookom
JayRo71
  • Locked
  • Question
Importing only unique records from excel tables 1
Replies
10
Views
173
SkipVought
S
03Explorer
  • Locked
  • Question
Refreshing a linked table (housed on MS SQL Server) now breaks
Replies
3
Views
89
dhookom
dhookom
v5652
  • Locked
  • Question
Trouble opening database Make sure the drive is available
Replies
2
Views
104
v5652
v5652
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
108
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top