Differences

This shows you the differences between two versions of the page.

--- database:access [2015/11/27 21:53] – mnewnham
+++ v5:database:access [2020/01/13 13:06] (current) – Add tier2 tag dregad
@@ Line 6: / Line 6: @@
 == Specification ==
 ^Driver Name|access|
-^Data Provider|access|
+^Data Provider|odbc|
 ^Status|Active((This driver is actively supported by ADOdb project members)) |
 ^Windows|Yes|
@@ Line 13: / Line 13: @@
 ^ADOdb V6|Yes|
 == Alternatives ==
-[[database:ado|ADO Driver For Access]]\\
+[[v5:database:pdo#pdo_access|PDO Driver For Access]]
-[[database:pdo#pdo_access|PDO Driver For Access]]
 </WRAP>
@@ Line 21: / Line 20: @@
 ===== Driver Specific Options =====
 None
+===== Driver Specific Issues =====
+In ADOdb V5, the field type returned in [[v5:dictionary:metacolumns]] is the metaType, not the actualType. For more on this issue, see [[https://github.com/ADOdb/ADOdb/issues/184|This Thread]] on Github. This behaviour changed in Version 5.21, but a backward compatibility mode is provided:
+-----------------------
+<code php>
+$db = newAdoConnection('access');
+$db->metaColumnsReturnType = METACOLUMNS_RETURNS_META;
+</code>
+Depending on the database security, some meta functions may not be available. For more information, try this [[http://stackoverflow.com/questions/1937703/record-cannot-be-read-no-read-permission-on-msysobjects|Stack Overflow]] response.
 ---------------------------
 ===== Connection Parameters Guidelines =====
@@ Line 49: / Line 57: @@
 </code>
-{{tag>[access supported]}}
+{{tag>[access supported tier2]}}