create text view using adp interface

[Guest]

I only have Access ADP to access MS SQL server.
I would like to create view using ADP interface.
Does it have method to create text view like create text stored procedures?

Thanks millions for the information,

 

[Philipp Stiefel]

I only have Access ADP to access MS SQL server.
I would like to create view using ADP interface.
Does it have method to create text view like create text stored procedures?

If you create a view using the Access-Interface you can switch
on the SQL-View ([SQL]-Button in the main Toolbar) and create
the view by writing the SQL-Statement defining the view.
- Unfortunately there is no sytax highlighting available.

HTH
Phil

 

[dbahooker]

i personally think that they should have a 'create view text' option in
there; since i've had a LOT of situations where views won't work and/or
ADP rewrites views; and i dont want to gamble

of course-- if i was in charge of ADP; they would WORK and they would
be TESTED. and we all know that isn't the case lol

you also can write a sproc to do that.. or at least you should be able
to.

create sproc sphappy as

create view myview
as
select * from sysobjects