DBMS | RDBMS

J

John Vinson

Is Access a DBMS or RDBMS

Purists will argue for hours on this subject (Access is not fully
compliant with the ANSI SQL standard, doesn't store its table
definitions in accessible relational tables, etc.) but essentially
it's both: a relational database management system.

Nitpick: Access itself isn't a database management system at all. It's
a user interface to (by default) the JET database engine, but it can
be used as a user interface to SQL/Server, MySQL, Oracle, or any ODBC
compliant database engine. To the user, though, the Jet engine is
integral to Access, so in practice one would refer to "Access/JET" as
one bundle.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top