Why my records are read only?

[Al]

I have an access front end with sql server 2005 back end. when I run the
following code:

Set db = CurrentDb()
Set rst = db.OpenRecordset("tblUserLog",
dbOpenDynaset, dbSeeChanges, dbOptimistic)

With rst
.AddNew
![UserID] = Me![SelectUser]
.Update
End With

The code break on .AddNew and gives me the error message "Cannot update.
Database or Object is read-only"

even though the account I use has the read/write permession and has the
sysadmin role.
any idea?
thanks

 

[Douglas J. Steele]

Does tblUserLog have a primary key defined on it? Unless there's a unique
index on the table, it's going to be read-only when connecting using ODBC.

 

[Al]

Yes you are right. that fixed it.thnx

Does tblUserLog have a primary key defined on it? Unless there's a unique
index on the table, it's going to be read-only when connecting using ODBC.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have an access front end with sql server 2005 back end. when I run the
following code:

Set db = CurrentDb()
Set rst =
db.OpenRecordset("tblUserLog",
dbOpenDynaset, dbSeeChanges, dbOptimistic)

With rst
.AddNew
![UserID] =
Me![SelectUser]
.Update
End With

The code break on .AddNew and gives me the error message "Cannot update.
Database or Object is read-only"

even though the account I use has the read/write permession and has the
sysadmin role.
any idea?
thanks