Re: Creating a VIEW OR Updating a VIEW

Tech-Archive recommends: Fix windows errors by optimizing your registry



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

  • Re: Stored Procedure
    ... actually help states that there is a CREATE PROCEDURE Statement: ... Note The Microsoft Jet database engine does not support the use of CREATE PROCEDURE, or any of the DDL statements, with non-Microsoft Jet database engine databases. ...
    (microsoft.public.access.modulesdaovba)
  • 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)