October 28, 2009 at 7:29 am
I use MSAccess as my front end. We may move to VB.Net but that is down the road.
When using a table in Access a User can read and write (given the proper permissions).
However, using a view the user can only read the data.
I would like to use a where clause which is available in Views to filter/narrow the amount of info. Is there way to to but read and write with a view?
Is ther another way to accomplish this.
Thank you,
October 28, 2009 at 10:46 am
--EDIT--
My comment from 4 years ago was so wrong I removed it as to not be misleading. :blush:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 28, 2009 at 10:55 am
Hi Ken
If your table is just needed for any offline information which are not related to the rest of your database you can either keep a local Access database or use a SQL Server Compact database.
Greets
Flo
October 28, 2009 at 11:18 am
This might help you better understand what you can do using a view:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/aecc2f73-2ab5-4db9-b1e6-2f9e3c601fb9.htm
From the above Books On Line entry
You can modify the data of an underlying base table through a view, as long as the following conditions are true:
Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table.
The columns being modified in the view must directly reference the underlying data in the table columns. The columns cannot be derived in any other way, such as through the following:
An aggregate function: AVG, COUNT, SUM, MIN, MAX, GROUPING, STDEV, STDEVP, VAR, and VARP.
A computation. The column cannot be computed from an expression that uses other columns. Columns that are formed by using the set operators UNION, UNION ALL, CROSSJOIN, EXCEPT, and INTERSECT amount to a computation and are also not updatable.
The columns being modified are not affected by GROUP BY, HAVING, or DISTINCT clauses.
TOP is not used anywhere in the select_statement of the view together with the WITH CHECK OPTION clause.
October 28, 2009 at 3:03 pm
If I open the View from the Mangement Console/Studio I can add/edit rows, no problem.
If I link to in in Access, I can add/edit rows from tables but not views.
October 3, 2013 at 8:17 am
there is a tool/service that is free and worth cheking to help you with sql db
that have a gui interface with C.R.U.D functionality and role based security, Excel import/export and a chart module. check it at Modubiz.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply