[QODBC-ALL] QODBC shows RegFile1 License error when using MS Excel 2013 or Access 2013 - Excel Crash / Access Crash
Posted by Rajendra Dewani (QODBC Support) on 08 May 2013 12:38 PM
QODBC Shows a RegFile1 License error when using MS Excel 2013 or Access 2013
MS Excel 2013 or Access 2013 Shows This function requires activation of QODBC Read Write or Server Edition.
MS Excel 2013 or Access 2013 (Office 365) crashes when trying to connect to QuickBooks Data.
Note: For Automatic Fix/Patch, Click Here
Note: VB Demo is deprecated.
Please refer to How to use the QODBC Test Tool for testing
The Test Connection in the QODBC Setup Screen comes back saying it is connected, and the VB Demo returns results. Still, Excel crashes as soon as you select using the QuickBooks Data* Database option in the connection wizard.
I cannot get data connections to work with either Access or Excel 2013 32-bit.
Environment: MS Office 2013/365/2016, QuickBooks 2013, Windows 7 or Above. When connecting with VB, Demo can connect, but when using Excel or Access, QODBC shows the error "RegFile1 License error."
This issue only happens when using MS Office 2013 and not with MS Office 2010 or downwards.
MS Office is not allowing to write to the registry; thus, QODBC has this error.
One-time activity, Run Excel/Access and QuickBooks ( Both ) as Elevated (Run as Administrator), and connect once. After it's connected, you can run Excel/Access and QuickBooks in normal mode.
In This example, we will be using MS Access, but the same steps apply to MS Excel
Close all the applications
Make sure QBW32.exe, msaccess.exe, msexcel.exe, access.exe, excel.exe is NOT running.
Please verify using Task Manager ( Processes - View all user processes)
Right Click on QuickBooks and Click "Run As Administrator"
Login to your company file as Admin, Switch to Single User Mode
Right Click on MS Access and Click "Run As Administrator" ( In case "Run as Administrator" does not appear on Right click, please hold the Shift Key and then Right Click on the shortcut)
A default database filename, Database1, appears in the box. You can edit this to a more relevant name, such as QB Link. accdb. Save the file as type "Microsoft Office Access Databases."
Then Click "Create" to create a blank database:
After the new database is created, Navigate to "External Data":
Build a connection via External Data->More->ODBC Database, or directly click the ODBC database button at the External Data menu:
Under the Get External Data window, you will get two options:
Import the source data into a new table in the current database. This option will directly extract tables into Access Database, you can view and edit these tables, but all modifications will not be uploaded unless you build another query.
Link to the data source by creating a linked table: this option will create a table just like the first option but will keep its link to QuickBooks, which means all your operations to this table will be uploaded to QuickBooks, and the data in the table is also in full sync with QuickBooks.
This article will show you how to build the linked table in MS Access.
Build a Linked Table in MS Access
After you select the access method and click OK, then you will get a Select Data Source window:
Select the QuickBooks-related DSN you set up with the QODBC driver. This can be one of our pre-installed DSN names or one that you have created. (Here, I choose the default DSN as the example.)
The first time you use MS Access to access QuickBooks, it will ask you to grant permission for this application:
Select the "Yes, Always" option, and then click "Done" in the next window:
Once the connection is built, Access will return a list of available tables in the Select Tables window. Please, select the tables you want to extract data from. Multiple Selection is available.
If the Import/Linking works without any problems, you will see linked tables been created in the table list of MS Access:
If you want to view QuickBooks records in this linked table, double-click the linked server, then you will see the records:
Close MS Access
Please verify using Windows Task Manager ( Processes - View all user processes) that there is no Process of QuickBooks ( i.e., QBW32.exe ) and Access is running ( msaccess.exe, msexcel.exe, access.exe, excel.exe )
Start MS Access & QuickBooks - Normally
Perform a test
In case you are still facing issues, please raise a support ticket.
Keywords: regfile 1license error
MS Excel 2013 or Access 2013
"Expired Evaluation" error message even though activated license
Excel crash, Access Crash, Excel 2016 crash, Access 2016 crash