[AccessD] Ace versus Jet SQL

Martin Reid mwp.reid at qub.ac.uk
Tue Jan 10 13:04:06 CST 2012


http://msdn.microsoft.com/en-us/library/ff965871.aspx

Looks at ace

End of day its a database engine which uses SQL.

martin


Sent from my Windows Phone
________________________________
From: Susan Harkins
Sent: 10/01/2012 18:55
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Ace versus Jet SQL

I've seen a few refer to Ace Jet and it just makes sense to me. I can't find
a definitive answer though, even at microsoft.com.

Susan H.


>
> Good question!  I've never seen anything other then "JET SQL" anywhere
> (even MSKBs).  ACE really is nothing more then JET with a couple of tweaks
> and the SQL at this point is the same as far as I know.
>
> But at some point, they might become different.
>
> I'd say break new ground and be the first<g>.
>
> Jim.
>
>
> How do we correctly refer to the Access-dialect of SQL for ribbon
> versions?
> Do we now have Jet SQL and Ace SQL or is it just Jet SQL for everything?
>
> Susan H.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list