New project, existing data, can't insert new records 1

[TexasToast]

I am trying to set up a new Access project (2002 and 2003) to manage an existing SQL7 database. No matter what authentication I give it, I can never insert a new record.

This db was an Access mdb that I imported into a new (blank) database in SQL7.

I'm new(ish) to SQL and ADP's, so I don't know if this is by design (doesn't seem likely), or if I'm doing something wrong (more likely). I need to create a form to enter information into this database, but I can't seem to modify the database at all.

I have tried setting up the connection using a SQL account that was specifically in the DATAWRITER role, I've tried specifically giving that SQL account INSERT and UPDATE permissions to the database and the table, I've tried using the dbowner, I've even tried using the sa account. I can't update the records or insert new records.

What am I doing wrong?

The only feed back Access gives me is when I click into a field in a table, the status bar says "recordset not updateable".

TIA, TT

 

[cjowsey]

First ensure that you can upate the database using raw SQL. Use the SQL Server Query Analyser to do a simple update of a table. If that works, and I expect it will, then it is a problem on the ADP side.

It sounds like you don't have a primary key on your tables. Access can not update SQL Server recordsets unless you define a primary key for each table.

 

[TexasToast]

You are right. I didn't set up the primary keys after importing the database. Thank you very much.