Inserting records

  • Thread starter Thread starter Brian
  • Start date Start date
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?
 
Does the table have a primary key that Access knows about? Can you edit
records or read records?
 
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"
 
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.
 
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).
 
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
 
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
 
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
 
Back
Top