Access databases (MS Access) - Revision history

Jakeh: /* MS Access 2013 */

2013-04-20T20:02:42Z

‎MS Access 2013

2013-04-20T19:38:42Z

‎MS Access 2010

2013-04-20T19:38:02Z

‎MS Access 2003: .mdb

2013-04-20T19:37:46Z

‎MS Access 2007

2013-04-20T19:37:18Z

‎MS Access 2003 .mdb

2013-04-20T19:12:01Z

‎800a0e7a Error

2013-04-20T17:22:58Z

2012-11-21T10:12:20Z

2012-07-05T07:05:32Z

2012-07-05T07:00:13Z

@@ Line 11: / Line 11: @@
 NOTE:  For ColdFusion sites we strongly suggest for performance to convert the Access database to MySQL or MS SQL.  We are happy to do this for you if needed.  You can also follow the steps we have in this wiki to do this yourself if wanted.  You will see major improvements in performance.
-===MS Access 2003: .mdb===
+===MS Access 2003===
 ===MS Access 2007===

@@ Line 14: / Line 14: @@
 ===MS Access 2007===
 ===MS Access 2010===
 ===MS Access 2013===

@@ Line 11: / Line 11: @@
 NOTE:  For ColdFusion sites we strongly suggest for performance to convert the Access database to MySQL or MS SQL.  We are happy to do this for you if needed.  You can also follow the steps we have in this wiki to do this yourself if wanted.  You will see major improvements in performance.
-===MS Access 2003 .mdb===
+===MS Access 2003: .mdb===
 ===MS Access 2007===
 ===MS Access 2010===

← Older revision		Revision as of 19:12, 20 April 2013
Line 26:		Line 26:
	Provider cannot be found. It may not be properly installed.		Provider cannot be found. It may not be properly installed.

−	~~/config.inc.asp, line 21~~
	</pre>		</pre>

@@ Line 6: / Line 6: @@
 NOTE: MS Access 97 and later versions are supported. However, when possible we suggest you upgrade the database to MS Access 2000 or later.  Further, we strongly suggest converting the database to MySQL or MS SQL.
-== Troubleshooting ==
+==MS Access database versions supported==
 ===800a0e7a Error===

← Older revision		Revision as of 10:12, 21 November 2012
Line 49:		Line 49:
	</pre>		</pre>

		+	===Error: Operation Must use an Updateable Query===
		+	Your ASP pages are trying to insert/update a record in a database that does not have write permissions.
		+
		+	Submit a request via our online Support Ticket system and we will get the permissions set for you. Just let us know what folder contains the database.
		+
		+	NOTE: We recommend you place your database files in a folder by themselves.

	[[Category:Databases-Access]]		[[Category:Databases-Access]]

@@ Line 8: / Line 8: @@
 == Troubleshooting ==
 ===800a0e7a Error===
 <pre>
@@ Line 16: / Line 18: @@
 /config.inc.asp, line 21
 </pre>
 CHANGE:
@@ Line 29: / Line 29: @@
 === 80004005 Error ===
 <pre>
@@ Line 37: / Line 39: @@
 /config.inc.asp, line 31
 </pre>
 CHANGE:

← Older revision		Revision as of 07:00, 5 July 2012
Line 5:		Line 5:

	NOTE: MS Access 97 and later versions are supported. However, when possible we suggest you upgrade the database to MS Access 2000 or later. Further, we strongly suggest converting the database to MySQL or MS SQL.		NOTE: MS Access 97 and later versions are supported. However, when possible we suggest you upgrade the database to MS Access 2000 or later. Further, we strongly suggest converting the database to MySQL or MS SQL.
		+
		+	== Troubleshooting ==
		+	===800a0e7a Error===
		+
		+	<pre>
		+	ADODB.Connection error '800a0e7a'
		+
		+	Provider cannot be found. It may not be properly installed.
		+
		+	/config.inc.asp, line 21
		+	</pre>
		+
		+	If you receive the error above it may be because you are on a Windows 2008 Server and need to update your connection string to use the 64-bit Access driver:
		+
		+	CHANGE:
		+	<pre>
		+	Provider=Microsoft.Jet.OLEDB.4.0;
		+	</pre>
		+	TO:
		+	<pre>
		+	Provider=Microsoft.ACE.OLEDB.12.0;
		+	</pre>
		+
		+	=== 80004005 Error ===
		+
		+	<pre>
		+	Microsoft OLE DB Provider for ODBC Drivers error '80004005'
		+
		+	[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
		+
		+	/config.inc.asp, line 31
		+	</pre>
		+
		+	If you receive the error above it may be because you need to update the Access driver in your code as shown below:
		+
		+	CHANGE:
		+	<pre>
		+	Driver={Microsoft Access Driver (*.mdb)};
		+	</pre>
		+	TO:
		+	<pre>
		+	Driver={Microsoft Access Driver (.mdb, .accdb)};
		+	</pre>


	[[Category:Databases-Access]]		[[Category:Databases-Access]]