Does Access 2000 support SQL2?

  • Thread starter Thread starter Billy Smith
  • Start date Start date
B

Billy Smith

I'm using Access 2000. I'm studying some complex joins in a book that says
SQL2 will do some things that SQL1 will not. Does Access 2000 support SQL2
queries?
 
How you structure your SQL in Access depends on the back end database you are
using. If it is all in Access, that is using Access tables, then you will
have to use Jet SQL. If you are using a database engine other than Jet, you
can use whatever SQL that engine supports.

In other words, Access is really just the "front end" that allows you to
build applicatons. It is not a database engine. When you are using SQL, it
has to conform to the requirements of the database engine.
 
Great answer. Thanks a lot.

--Billy

Klatuu said:
How you structure your SQL in Access depends on the back end database you
are
using. If it is all in Access, that is using Access tables, then you will
have to use Jet SQL. If you are using a database engine other than Jet,
you
can use whatever SQL that engine supports.

In other words, Access is really just the "front end" that allows you to
build applicatons. It is not a database engine. When you are using SQL,
it
has to conform to the requirements of the database engine.
Click to expand...
 
Back
Top