Access 2007 "This Recordset is not Updateable"

  • Thread starter Thread starter denyoung
  • Start date Start date
D

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.
 
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?
 
denyoung said:
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?
Click to expand...

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/
 
Thank you both - it is definitely a TS user permission problem. I need to do
some more work there.
 
Back
Top