create text view using adp interface

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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?
Click to expand...

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
 
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
 
Back
Top