Difference between revisions of "Access databases (MS Access)"
(Created page with "Yes we do support MS Access databases on our Windows servers. We support both DSN and DSN-less connections. There is no charge for setting up a DSN and you can set it up thro...") |
m (→MS Access 2013) |
||
| (15 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | == MS Access Databases - General Information == | |
| + | We do support MS Access databases on our Windows servers. | ||
| − | We support both DSN and DSN-less connections. | + | We support both DSN and DSN-less connections. The DSN can be set up through your Account Control Panel. |
| − | NOTE: MS Access 97 and later versions are supported. However, when possible we suggest you upgrade the database to MS Access 2000 or later. | + | 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. |
| + | ==MS Access database versions supported== | ||
| + | Most all versions of MS Access are supported. | ||
| − | [[ | + | 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 2007=== | ||
| + | *accdb | ||
| + | *mdb | ||
| + | |||
| + | ===MS Access 2010=== | ||
| + | *accdb | ||
| + | *mdb | ||
| + | |||
| + | ===MS Access 2013=== | ||
| + | *accdb | ||
| + | *mdb | ||
| + | |||
| + | ==Troubleshooting MS Access== | ||
| + | ===800a0e7a Error=== | ||
| + | |||
| + | If you receive the error below 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: | ||
| + | |||
| + | <pre> | ||
| + | ADODB.Connection error '800a0e7a' | ||
| + | |||
| + | Provider cannot be found. It may not be properly installed. | ||
| + | |||
| + | </pre> | ||
| + | |||
| + | CHANGE: | ||
| + | <pre> | ||
| + | Provider=Microsoft.Jet.OLEDB.4.0; | ||
| + | </pre> | ||
| + | TO: | ||
| + | <pre> | ||
| + | Provider=Microsoft.ACE.OLEDB.12.0; | ||
| + | </pre> | ||
| + | |||
| + | === 80004005 Error === | ||
| + | |||
| + | If you receive the error below it may be because you need to update the Access driver in your code as shown below: | ||
| + | |||
| + | <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> | ||
| + | |||
| + | CHANGE: | ||
| + | <pre> | ||
| + | Driver={Microsoft Access Driver (*.mdb)}; | ||
| + | </pre> | ||
| + | TO: | ||
| + | <pre> | ||
| + | Driver={Microsoft Access Driver (*.mdb, *.accdb)}; | ||
| + | </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]] | ||
Latest revision as of 20:02, 20 April 2013
Contents
MS Access Databases - General Information
We do support MS Access databases on our Windows servers.
We support both DSN and DSN-less connections. The DSN can be set up through your Account Control Panel.
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.
MS Access database versions supported
Most all versions of MS Access are supported.
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 2007
- accdb
- mdb
MS Access 2010
- accdb
- mdb
MS Access 2013
- accdb
- mdb
Troubleshooting MS Access
800a0e7a Error
If you receive the error below 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:
ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed.
CHANGE:
Provider=Microsoft.Jet.OLEDB.4.0;
TO:
Provider=Microsoft.ACE.OLEDB.12.0;
80004005 Error
If you receive the error below it may be because you need to update the Access driver in your code as shown below:
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
CHANGE:
Driver={Microsoft Access Driver (*.mdb)};
TO:
Driver={Microsoft Access Driver (*.mdb, *.accdb)};
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.