By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,234 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,234 IT Pros & Developers. It's quick & easy.

Views not

P: n/a
Can anyone tell me why I get:
"This Recordset is not updatable"
when trying to edit data in an Access2000 .adp View that has only one
table in the view?
Any help is appreciated.
lq
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Often, you need to include the key id, and also the timestamp in the view.
Since one has to use "update" commands to update the data, if key fields are
not included, then ms-access can be confused.

It is also perhaps possible that security on the table is in place.
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
No************@msn.com
http://www.attcanada.net/~kallal.msn
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.