Re: Creating a VIEW OR Updating a VIEW

My bad. Knowing a little can be a dangerous thing. I was quoting Access
help:
Note The Microsoft Jet database engine does not support the use of CREATE
VIEW, or any of the DDL statements, with non-Microsoft Jet database engine
databases.

Left out the last line.

Damon

"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote in message
news:Xns98F879C01EC44f99a49ed1d0c49c5bbb2@xxxxxxxxxxxx

"Damon Heron" <damon327@xxxxxxxxxxx> wrote in
news:Qd6dnaxYQc4yPWPYnZ2dnUVZ_qmpnZ2d@xxxxxxxxxxx:

CREATE, DROP & ALTER are not supported by Jet db engine.

For what objects? For tables and relationships, of course they are
supported.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/


.

Relevant Pages

  • DTS error -2147467259
    ... It works great if I run the package manually. ... Error source: Microsoft JET Database Engine ... DTSRun OnStart: Copy Data from Results to Results Step ...
    (microsoft.public.sqlserver.dts)
  • Re: dts and access db
    ... The pkg doesn't fail manually, ... Error source: Microsoft JET Database Engine Help file: ...
    (microsoft.public.sqlserver.dts)
  • Dragonfly Shopping Cart Multiple vulnerabilities
    ... Microsoft JET Database Engine error '80040e07' ... Data type mismatch in criteria expression. ...
    (Bugtraq)
  • Re: Select from first worksheet without knowing its name
    ... Make sure the object exists and that you spell its name and the path name correctly. ... The Microsoft Jet database engine could not find the object 'Sheets.Active'. ... >> Dim myds As New DataSet ...
    (microsoft.public.excel.programming)
  • Problem reading data from Access 2000
    ... Jet database engine cannot open the file ''. ... SQLSetConnectAttr failed ERROR [ODBC Microsoft Access ... Driver] The Microsoft Jet database engine cannot open the file ... need permission to view its data. ...
    (microsoft.public.dotnet.framework.adonet)