Re: Creating a VIEW OR Updating a VIEW

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

From: "Damon Heron" <damon327@xxxxxxxxxxx>
Date: Mon, 19 Mar 2007 09:26:43 -0700

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/

References:
- Creating a VIEW OR Updating a VIEW
  - From: jmarr02s
- Re: Creating a VIEW OR Updating a VIEW
  - From: Damon Heron
- Re: Creating a VIEW OR Updating a VIEW
  - From: David W. Fenton

Prev by Date: Re: Form/SubForm Design
Next by Date: Re: Cancel = True still letting user exit
Previous by thread: Re: Creating a VIEW OR Updating a VIEW
Next by thread: Re: Allen Browne Client Search Multiple Like Statements
Index(es):
- Date
- Thread

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)