Re: CREATE VIEW error

Reduce the complexity until you find where it's breaking

"Edwin Knoppert" <info@xxxxxxxxxxxxxxxxxxx> wrote in message
news:e4l7d4$97b$1@xxxxxxxxxxxxxxxxxx
To answer the responses so far:

This is an access MDB used in ASP.NET v2.0
The website is hosted by a webhosting company, we only have access through
ftp.

Yes, we have the project locally, i'm testing this create view stuff
locally.
The idea is that i need to write me complex queries, to complex for me
unless i prepare multiple querydefs (views) using each other.

To avoid downloading the database for maintanance i wanted to insert new
queries remote.
I'm just taking existing querydef's from the access database which work(!)
and try to create them using Execute() stuff.
'Simple' queries do get inserted, the example i shown does not.. ???

I simply use an ASPX having a textbox being passed to the execute command.
Liek i said, it works until it's getting complicated according the error
message i get.




"Edwin Knoppert" <news@xxxxxxxxxxxxxx> schreef in bericht
news:446dbb14$0$2021$ba620dc5@xxxxxxxxxxxxxxxxxxxxxx
I have serious issue by inserting a query using (names are fake):

CREATE VIEW Query1 AS
SELECT Count(Table1.ID) AS CountOfID, Day([DatumAanmaak]) AS Dag,
Month([DatumAanmaak]) AS Maand, Year([DatumAanmaak]) AS Jaar
FROM Table1
GROUP BY Day([DatumAanmaak]), Month([DatumAanmaak]),
Year([DatumAanmaak]), Day([DatumAanmaak]), Month([DatumAanmaak]),
Year([DatumAanmaak])
HAVING (((Year([DatumAanmaak]))=Year(Date())))
ORDER BY Year([DatumAanmaak]) DESC , Month([DatumAanmaak]) DESC ,
Day([DatumAanmaak]) DESC;

"Only simple SELECT queries are allowed in VIEWS."

Can this be solved?






.

Relevant Pages

  • Re: Data Access Pages
    ... > queries, forms and macros to enable it to be operated over the internet. ... > data can be edited manually via data access forms, ... if there are any example of access database being controlled via web ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access and Excel
    ... via append queries and update queries. ... > Excel spreadsheets. ... > wanting to create some sort of Access database for her as ...
    (microsoft.public.access.tablesdbdesign)
  • Re: office 2003 Word mailmerge with Access
    ... If you aren't able to see all of the queries then ... it's likely due to the connection method rather than permissions. ... Select the Access database as the data source again and when ...
    (microsoft.public.office.misc)
  • Re: Mail merge from access Database
    ... Word 2003 uses a thing called OLE DB to connect to the Access database. ... however, both Access tables and Access Queries are listed in that dialog box, although Queries are described as Views. ... OLE DB does not "see" all types of table and query. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: CREATE VIEW error
    ... The idea is that i need to write me complex queries, ... I'm just taking existing querydef's from the access database which work ... I simply use an ASPX having a textbox being passed to the execute command. ...
    (microsoft.public.dotnet.framework.adonet)
Loading