3 * Microsoft Access ADO driver.
5 * Requires ADO and ODBC. Works only on MS Windows.
7 * This file is part of ADOdb, a Database Abstraction Layer library for PHP.
10 * @link https://adodb.org Project's web site and documentation
11 * @link https://github.com/ADOdb/ADOdb Source code and issue tracker
13 * The ADOdb Library is dual-licensed, released under both the BSD 3-Clause
14 * and the GNU Lesser General Public Licence (LGPL) v2.1 or, at your option,
15 * any later version. This means you can use it in proprietary products.
16 * See the LICENSE.md file distributed with this source code for details.
17 * @license BSD-3-Clause
18 * @license LGPL-2.1-or-later
20 * @copyright 2000-2013 John Lim
21 * @copyright 2014 Damien Regad, Mark Newnham and the ADOdb community
24 // security - hide paths
25 if (!defined('ADODB_DIR')) die();
27 if (!defined('_ADODB_ADO_LAYER')) {
28 include_once(ADODB_DIR
. "/drivers/adodb-ado5.inc.php");
31 class ADODB_ado_access
extends ADODB_ado
{
32 var $databaseType = 'ado_access';
33 var $hasTop = 'top'; // support mssql SELECT TOP 10 * FROM TABLE
34 var $fmtDate = "#Y-m-d#";
35 var $fmtTimeStamp = "#Y-m-d h:i:sA#";// note no comma
36 var $sysDate = "FORMAT(NOW,'yyyy-mm-dd')";
37 var $sysTimeStamp = 'NOW';
38 var $upperCase = 'ucase';
40 /*function BeginTrans() { return false;}
42 function CommitTrans() { return false;}
44 function RollbackTrans() { return false;}*/
49 class ADORecordSet_ado_access
extends ADORecordSet_ado
{
51 var $databaseType = "ado_access";