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

  • Thread starter Thread starter Özden Irmak
  • Start date Start date
Ö

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