Short definition is that it is a different "flavor" of Access that ties
directly to a SQL Server back-end, has no local storage for tables and uses
the SQL Server engine instead of Jet. Many use ADP as a way to manipulate
database level objects in SQL Server.
I'm sure others will add to or "Wiki" the above, but those are the basics