Access project always in Read-only mode

[Berge]

Hi there !
I have a problem with my Access Project...

This Access project (.adp) is connected to a SQL Server database, with Windows NT Integrated security login...
I can see all my tables, views and store proc. of my SQL Server database, but i can't make any Insert, update or delete operation...

Can someone help me ?

Ho yeah, and i also give to my user the permision to select, insert, update and delete on my tables... (in SQL Server)

I still don't understand why the recordset of my tables are in read-only mode in access

 

[bcallnan]

Access Project will not let me edit tables

I have the same problem as this user.
I have not been able to update tables on SQL Server. I have checked with the dba and he states that all of my permissions have been set to owner. I am able to write and delete tables in the project but am unable to update individual records. When I do this in SQL Server Enterprise Manager, I have no problems. I must be missing something- Anyone have an idea?
Thanks!!

 

[boblarson]

Do your tables on SQL Server have a primary key defined?

 

[bcallnan]

Nope- they did not-
Thank you- I am able to edit them now.
-- Must've missed that fact... thanks again for the fast reply!
-Brian

 

[boblarson]

Glad we could get you on track!