Access 2007 "This Recordset is not Updateable"

[denyoung]

I am setting up a multiuser Access 2007 database (with FE/BE) that works fine
for local network users but that can only be "viewed" by Terminal Server
users. When attempting to edit any table in either form or datasheet view, I
get the message "This Recordset is not updateable". Is this a TS issue or an
Access issue?

Thanks.

 

[Paul Shapiro]

It sounds like a permissions issue for the TS user. Does the TS user have
the same permissions as the local users on the BE folder and the BE db file?

 

[Tony Toews [MVP]]

I am setting up a multiuser Access 2007 database (with FE/BE) that works fine
for local network users but that can only be "viewed" by Terminal Server
users. When attempting to edit any table in either form or datasheet view, I
get the message "This Recordset is not updateable". Is this a TS issue or an
Access issue?

To add to Paul's comments - Can the TS user create and update a .txt
file on the BE folder using Notepad? That will quickly show if it is
a network permissions problem or not.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[denyoung]

Thank you both - it is definitely a TS user permission problem. I need to do
some more work there.