Category:Microsoft Access

From database24
Revision as of 13:10, 22 July 2010 by Dec (talk | contribs)
Jump to navigation Jump to search

Microsoft Access vs Jet Database Engine

Technically speaking "Microsoft Access" is a front end for the "Jet Database Engine". For the sake of simplicity and as many people do not know the difference, "Microsoft Access" will henceforth be used synonymously for the "Jet Database Engine".

Coding

Special Objects

  • System tables (MSys)
  • Temporary tables (~sq_f*)

SQL

  • OLEDB-Queries
  • No ALTER VIEW etc