The Microsoft Access accdb ODBC Driver driver can be used to connect to the following data sources: AccessAccess 2000Access 2002Access 2003Access 2007Access 2010Access 2013Access 97. To see available connection options, navigate to the connection strings reference by the above links. Otherwise, the 2010 Access Database Engine (32-bit) can be installed. After installing the engine, several new drivers appear in the ODBC Data Source Manager, including drivers that are able to read.accdb files. The Microsoft Access Driver now lists.accdb as a file type it supports. Before and After.
![]() -->
Note
This topic provides Access Driver-specific information. For general information about this function, see the appropriate topic under ODBC API Reference.
The SQLConfigDataSource function that is used to add, modify, or delete a data source dynamically uses the following keywords.
Posted by: A Placer Date: September 11, 2015 10:34PM
I've been trying for days to migrate Access 2013 data to Workbench to which I wish to use from hereon. My Windows system is 7-64 bit Home Premium. I've followed forum & other instructions to point to SysWOW64 etc. The major problem evolves around the Access drivers. (Via the wizard), after selecting under User DSN tab Name: MS Access Database Driver: Microsoft Access Database (*.mdb, *accdb) when I go to Drivers Tab I can't find a Access driver option that also includes *.accdb option relevant to Access 2013. Result is I can't connect. To get around this I went into Access 2013 and saved the file to an earlier *.mdb version. This worked fine until the Workbench wizard got to last step ... 'Migration: Could not read from System Tables. You must grant SELECT access on all system tables for the database.' When I went into Access 2013 to grant access for this earlier version it still didn't work. I've tried to find a download for a MS access 2013 *.accdb inclusive driver without success. I did find ms link https://www.microsoft.com/en-au/download/details.aspx?id=13255 but being a newbie I have no idea of the implications of this download which '...install a set of components that can be used to facilitate transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications'. Furthermore, when I now click on User Access Database DSN it now returns the message 'The setup routines for Microft Access Driver (*mdb, *.accdb) ODBC driver could not be found. Please reinstall driver,' When hit OK button, it is followed by another window (Titled Driver's ConfigDSN,ConfigDriver, or ConfigTranslator failed) with 'Errors Found: Component not found in the registry' message. Same result if I click on the drivers whether in System32 or SysWOW64 folder. At my wits end and it's holding up opencart web implementation.
Options:Reply•Quote
Views
Posted
7391
September 11, 2015 10:34PM
2095
September 16, 2015 04:57AM
1765
![]()
September 17, 2015 07:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |