Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Front End Read and Write Expand / Collapse
Author
Message
Posted Wednesday, October 28, 2009 7:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 31, 2013 11:47 AM
Points: 128, Visits: 224
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,

Post #809916
Posted Wednesday, October 28, 2009 10:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:31 PM
Points: 13,207, Visits: 12,688
--EDIT--

My comment from 4 years ago was so wrong I removed it as to not be misleading.


_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #810137
Posted Wednesday, October 28, 2009 10:55 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 1,893, Visits: 3,932
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



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #810144
Posted Wednesday, October 28, 2009 11:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
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.



If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #810153
Posted Wednesday, October 28, 2009 3:03 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 31, 2013 11:47 AM
Points: 128, Visits: 224
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.

Post #810347
Posted Thursday, October 3, 2013 8:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 3, 2013 8:14 AM
Points: 1, Visits: 0
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
Post #1501215
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse