Reply to thread

Message

[QUOTE="Brian Hetrick, post: 600119"]
Umm, learning SQL would be a good first step.  An INSERT statement
inserts a row, even if it duplicates another row.  An UPDATE statement
has a WHERE selection clause telling what rows to update.  Either will
raise errors if constraints are violated.

[URL]http://www.devguru.com/technologies/jetsql/quickref/jet_sql_intro.html[/URL]
is a reasonable introduction to the SQL accepted by the Jet database
engine (what you get with Access), before Office 2000.  Microsoft
greatly enhanced the DDL aspects of Jet SQL, and included a lot of
ANSIisms it hadn't before, with Access 2000.  You can't get at these
through the Access UI or through DAO, but you can through ADO and
ODBC.  The new aspects are described in a series of three Access
technical articles at
[URL]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_2003_ta/html/odc_landAccess00_ta.asp[/URL].
The three articles are "Fundamental Microsoft Jet SQL for Access
2000," "Intermediate ...," and "Advanced ..."
[/QUOTE]

Verification