A question about views in sql server

From: "Mohamed Shafiee" <shafee_mohamed@xxxxxxxxxxx>
Date: Thu, 26 May 2005 21:09:29 +0500

Hi,

I just want to find out if it is possible to create views in SQL server
which can be updated in an adp project. Can we create a one-to-one
relationship between two tables in SQL server using database diagram, and
achieve an updateable view? How can we do this in MSAccess adp projects?

Shafiee.

.

Follow-Ups:
- Re: A question about views in sql server
  - From: James Goodman

Prev by Date: Re: CurrentUser() returning "Admin" for all Users?
Next by Date: Re: CurrentUser() returning "Admin" for all Users?
Previous by thread: SQL 10000 record limit
Next by thread: Re: A question about views in sql server
Index(es):
- Date
- Thread

Relevant Pages

Re: adp vc mdb
... Is ADP more efficient for reponse time, since it does not have local table? ... stick with the standard MDB file, and simply link the tables the SQL server. ... to deal with SQL server during your development process. ... then you'll likely get better performance with an ADP project. ...
(microsoft.public.access.forms)
Re: adp vc mdb
... stick with the standard MDB file, and simply link the tables the SQL server. ... work very efficiently as you design and build the application. ... to deal with SQL server during your development process. ... then you'll likely get better performance with an ADP project. ...
(microsoft.public.access.forms)
ADP encryption?
... I have created an ADP project that connects to SQL Server 2000. ... over the network? ... Prev by Date: ...
(microsoft.public.access.security)
Re: Transact SQL
... You do not use ADP project to connect to jet database. ... You use regular *.mdb as another *.mdb's front end ... >> SQL Server. ...
(microsoft.public.access.adp.sqlserver)
Re: A question about views in sql server
... As long as you have PK/FK fields on both tables (so that both tables are ... then this shouldnt be a problem. ... > I just want to find out if it is possible to create views in SQL server ... > which can be updated in an adp project. ...
(microsoft.public.access.adp.sqlserver)