create text view using adp interface

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Souris - 07 Oct 2005 04:12 GMT

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,

Reply to this Message

Philipp Stiefel - 07 Oct 2005 08:36 GMT

> 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

Reply to this Message

dbahooker@hotmail.com - 08 Oct 2005 01:40 GMT

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

Reply to this Message