Re: Create Table in External DB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: peregenem@xxxxxxxxxxxx
Date: 27 Jul 2005 01:05:15 -0700

david epsom dot com dot au wrote:
> > INTO [MS Access;Database=C:\db99.mdb;].Orders
>
> If you have your database set to 'ANSI' mode,
> you get may get SQL like this from the QBE window.

Perhaps, but the syntax I posted is from at least the Jet 3 era i.e.
not limited to Jet 4 which 'ANSI' mode implies.

> You also need the 'MS Access' clause if you are
> using an ADO connection instead of CurrentDB.

I use 'MS Access' simply to fully qualify the data source as, erm, Jet
:)

.

Follow-Ups:
- Re: Create Table in External DB
  - From: david epsom dot com dot au

References:
- Create Table in External DB
  - From: kremesch
- Re: Create Table in External DB
  - From: david epsom dot com dot au
- Re: Create Table in External DB
  - From: peregenem
- Re: Create Table in External DB
  - From: david epsom dot com dot au

Prev by Date: Re: Tools for record locking
Next by Date: RE: edit table data with query
Previous by thread: Re: Create Table in External DB
Next by thread: Re: Create Table in External DB
Index(es):
- Date
- Thread

Relevant Pages

Re: Bitwise And
... is saved/flagged as an 'ANSI' mode view or procedure. ... 'ANSI' queries can also (and this ... the SQL is also Jet complient SQL, ...
(microsoft.public.access.queries)
Re: Create Table in External DB
... but the syntax I posted is from at least the Jet 3 ... I was wrong to suggest that your SQL was 'ANSI' SQL. ... but the syntax I posted is from at least the Jet 3 era i.e. ...
(microsoft.public.access.queries)
Re: Better "Join" vs "Where" clause?
... Yes, MS SQL Server does it accordingly to the ANSI specs, while JET does ... While MS SQL Server and Jet indeed differ on this statement, ... I'm no expert on ANSI, so I'm not sure which is the behavior specified by ...
(microsoft.public.access.queries)