Inserting records

B

Brian

I verified that I have full permissions on a table and I
linked it using that account. However when I open the
table I have no ability to insert data. I am using Access
97 with a SQL2000sp3 database. Any thoughts?
 
D

Duane Hookom

Does the table have a primary key that Access knows about? Can you edit
records or read records?
 
G

Guest

No primary key has ever been defined. Prior to upgrading
from SQL6.5 to SQL2000 we were able to insert records.
However now I can view the tables but I get no insertable
row and if I try to change a record I get "This recorset
is not updatable"
 
J

John Vinson

I verified that I have full permissions on a table and I
linked it using that account. However when I open the
table I have no ability to insert data. I am using Access
97 with a SQL2000sp3 database. Any thoughts?
Click to expand...

Make sure that the SQL table has a Primary Key, and that it's defined
as the unique key to the table when you connect to it. Access will
prevent updating unless it knows that there is a PK.
 
D

Duane Hookom

You have to provide Access with a unique key. Create one in your SQL Server
table and then re-link the table so that Access can identify the unique
field(s).
 
T

TC

As the others have said, your table needs a primary key.

*ALL* your tables need primary keys!

You should not have any tables that do not have a primary key.

HTH,
TC
 
T

Tim Ferguson

Is this something new in SQL 2000?
Click to expand...

No: it's something very old in R theory. The PK is the method of
identifying records in a table; without a PK the db engine has no way of
knowing which one is which, so it has no way of updating anything reliably.

HTH


Tim F
 
T

TC

Tim Ferguson said:
Is this something new in SQL 2000?
Click to expand...

No: it's something very old in R theory. The PK is the method of
identifying records in a table; without a PK the db engine has no way of
knowing which one is which, so it has no way of updating anything[/QUOTE]
reliably.


Which is why I said to him: "*ALL* your tables need primary keys!"

But that may have fallen on dead ears :-(

TC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Providing only read/view permission of the email account to the user. (like Senior wants PS to only view his emails and not to respond or do action) 0
Change Style to 'Keep with previous' instead of Keep with Next 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
How to insert Certificated digital signature in Word for Mac 0
Adding data to MS Access from csv file 0
365 office launcher error 6
Mail Merge Directory Conditional Page Break 0
Word 97 Password 0

Top