It might be getting a little bit OT, but I searched and couldn't find the right definition of Jet SQL.
Microsoft claims it's close enough to the standard (though nowhere does it say in conforms to any standard). Devguru came in first on Google says... "Jet SQL has certain limitations compared to the other versions of SQL." I guess you can spin it either way, I've worked with Access years ago, so I don't know if they started fully conforming to SQL standards now, but back when I was working with it (Access 97, and a little Access 2000) a lot of standards were not followed. I can't recall what exactly at the moment, but if needed it definitelly wouldn't be hard to find:-) Ilya -----Original Message----- From: Mark Thornber To: Sterin, Ilya Cc: 'Terrence Brannon '; '[EMAIL PROTECTED] '; '[EMAIL PROTECTED] ' Sent: 10/16/01 2:31 AM Subject: Re: Postgres w/DBI > True, but I would rather not discuss Access SQL (Jet SQL). Don't > remember the last time MS willingly followed any standard. If I remember correctly Jet SQL was described by Microsoft as being an 'extended subset of the ANSI SQL Standard' -- MarkT
