Re: Selective views
From: AnthonyThomas (Anthony.Thomas_at_CommerceBank.com)
Date: 01/13/05
- Next message: AnthonyThomas: "Re: DB Design Question"
- Previous message: Mike Epprecht (SQL MVP): "RE: IDENTITY Column Insert"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 13 Jan 2005 01:10:08 -0600
The answer, "No," is correct, but the reasons are not. MS Access is NOT a
DBMS. MS Access is an interactive, client interface for the MS Jet,
semi-relational DBMS. MS Access project files are an interactive, client
interface for SQL Server.
If you create a MS Access database with links to SQL Server or pass-through
queries to SQL Server, then you can use the client-side ability of Access to
manipulate the information as you described but link to the base SQL Server
tables. However, then you would be creating MS Access queries, with the
interactive parameters, agains SQL Server base tables, or views, but these
would be Access queries, not SQL Server views.
Sincerely,
Anthony Thomas
-- "Scott Morris" <bogus@bogus.com> wrote in message news:ekeYI2W2EHA.1860@TK2MSFTNGP15.phx.gbl... Wasting your time. Access is both a client application and "dbms". SQL Server is just the dbms. "pjb" <pjb@discussions.microsoft.com> wrote in message news:1EDAB8A6-79B9-4EE2-B5B4-B31C5097B369@microsoft.com... > Is it possible to get a SQL view to return the values of a selected record in > the same way as an Access query? > eg in Access a query like this: > > SELECT dbo_units.unitname, dbo_units.region > FROM dbo_units > WHERE (((dbo_units.region)=[Select region])); > > Run this and you get a popup asking you to select the region, the query then > opens returning only the values where region matches the users input. > > I can't get a SQL view to do this. Am I wasting my time or can it be done?
- Next message: AnthonyThomas: "Re: DB Design Question"
- Previous message: Mike Epprecht (SQL MVP): "RE: IDENTITY Column Insert"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
