Re: MS Access SQL: duplicate record... ?SELECT INTO....?

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 06/30/04 

Date: Wed, 30 Jun 2004 00:15:55 -0400

> Maybe you meant "INSERT INTO pages(col2,col3) SELECT ...."
> instead of "INSERT pages(col2,col3) SELECT..."?

Maybe. Though, the INTO keyword is optional in the standard, and any decent
database won't complain when it's missing.

Relevant Pages

  • Re: eseutil /p will nicht brauche dringend Hilfe!!!
    ... provides information about recovering the database if error -1216 occurs. ... the re-integration of the missing files with the data set. ... you can use an option in Eseutil to override ... the error and proceed with soft recovery despite missing or mismatched ...
    (microsoft.public.de.german.exchange2000.general)
  • RE: Events to "Trap" Incomplete Record Creation?
    ... validation checks and issue a message if anything is missing. ... Joe CluelessUser is adding a new record to a database through a form. ... because of the missing required data. ...
    (microsoft.public.access.formscoding)
  • Project Games For Sale
    ... I have three games for sale. ... complete except is is missing some hanging pins. ... an 8 and the cabinet is fairly dirty, but pretty decent. ...
    (rec.games.pinball)
  • Re: Convert a2000 back to a97
    ... Your computer is missing some of the DLL's or TLB's that come with Access ... The proper way to fix the References is to open the application in Access ... has the database connection hard-coded to use data access methods specific ... Those simple loads and conversions you mentioned -- could ...
    (microsoft.public.access.conversion)
  • Re: Merge in Word
    ... (here's was missing at certain numbered entries - mine is variable). ... "Peter Jamieson" wrote: ... characters" - that sort of thing. ... work when I didn't use Excel for the database. ...
    (microsoft.public.word.mailmerge.fields)