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...

 

[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.torres]

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


Camilo

*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

-
c.torre