Error : -2147467259-Only simple SELECT queries are allowed in VIEWS ?

Ö

Özden Irmak

Hello,

I'm trying to create a view with running a "CREATE VIEW" command via Jet
Commannd Object. Although the view which is going to be created is fairly
simple, I'm getting this error :

-2147467259 - Only simple SELECT queries are allowed in VIEWS

Does anybody know why this happens and knows a solution?

Thanks in advance...
 
M

Michel Walsh

Hi,


If you have parameters, try a PROC rather than a view.

In Jet, a view is the same as a SELECT query without parameter and a
proc is the same as a SELECT query with parameters. You can't have more than
one statement. Use VBA to "merge" multiple statements.


Hoping it may help,
Vanderghast, Access MVP
 
C

c.torres

Hi, also try removing any ORDER BY in your query.


Camilo



Michel said:
*Hi,


If you have parameters, try a PROC rather than a view.

In Jet, a view is the same as a SELECT query without parameter and a
proc is the same as a SELECT query with parameters. You can't hav
more than
one statement. Use VBA to "merge" multiple statements.


Hoping it may help,
Vanderghast, Access MVP
Click to expand...


-
c.torre
 
Top