Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access General
ADP and SQL
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="chas, post: 763920"] Hi Ravi, A view based on multiple tables in SQL Server is by design non-updateable. Using the View as the basis of a Form in Access is OK as long as you set the UniqueTable property of the Form to the name of ONE table in the View that you want to update data in. Open the Form in design view, choose View>Properties and scroll the list until you find 'Unique Table'. hth chas [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access General
ADP and SQL
Top
