AccessBooks RealTime

AccessBooks RealTime

3.70 out of 5
(10 customer reviews)


Are you tired of poor or slow ODBC connections to your QuickBooks data? AccessBooks RealTime provides a QuickBooks export and sync solution. Using advanced database replication technology, AccessBooks RealTime natively synchronizes your QuickBooks company file to an external Microsoft Access database, or to a Microsoft SQL Server, MySQL or Oracle database in the Plus edition.

With the release of OpenSync 3.0 Read Only, we will be retiring AccessBooks RealTime. OpenSync 3.0 Read Only encompasses all AccessBooks RealTime functionality, is considerably more robust, and will by the sync solution we support moving forward.
Clear selection
SKU: ABRT. Category: . Tag: .
  Do you want to install AccessBooks RealTime on more than one computer? Copy for a friend perhaps? Buy additional licenses now and take 25% off your entire order. Massive savings!

Product Description

QuickBooks export made easy

AccessBooks RealTime provides a QuickBooks export that enables you to write queries that execute against a true database engine and achieve performance gains of up to 100% over the native QuickBooks QODBC driver. And if you also need to update QuickBooks, our AccessBooks Updater product will propagate changes made in the database back to QuickBooks. Now you can build truly scalable applications that share data with QuickBooks.

Additional Information

Supported QuickBooks Versions

QuickBooks 2004-2017 Pro, Premiere, and Enterprise


Microsoft Access for Standard versions or an instance of Microsoft SQL Server, MySQL, or Oracle database server for Plus versions.


AccessBooks RT version 7 provides access to all of the features supported by the QuickBooks 2011 programming interface. AccessBooks RealTime 7.0 also supports Oracle database servers.

You can choose minimize AccessBooks RT to the System Tray in the Options tab of Configure AccessBooks RT. To then minimize AccessBooks RT, you must click the red X in the upper right corner. To close the program, click Close AccessBooks RT.

As long as the path name and access permission is correct, you can run AccessBooks RT from a terminal server and access any QuickBooks company file on the network; however, you must have QuickBooks installed on the same workstation running AccessBooks RT.

No, because ListIDs aren’t unique over multiple company files, AccessBooks RT is restricted to one.

Synergration currently offers AccessBooks Updater, the complementary program to AccessBooks RT, which takes your AccessBooks database and imports it back into QuickBooks. A free 15-day trial is available for download.

Your install is most likely corrupted. Please reinstall AccessBooks RT. In addition, please ensure that you’re using a US, UK or Canadian version of QuickBooks Pro/Premier/Enterprise 2003 or later and the appropriate database software.

Either your path name to the specified database is incorrect or you need to install the appropriate database software. If you’re using MySQL, please ensure that your MySQL Connector/ODBC is up to date.

In order to access Accounts, you must have Allow this application to access Social Security Numbers, customer credit card information and other personal data selected for RT’s access permission. To change RTs access permission in QuickBooks go to Edit -> Preferences -> Integrated Applications -> Company Preferences, select AccessBooks RT and click Properties.

AccessBooks RT creates the entire qbXML structure for the databaase. Some of these vestigial tables, such as the Deleted tables, have negligible use, while others are only used by certain versions of QuickBooks, and as such, are not populated by RT.

Due to security changes in the latest version of the qbSDK, full credit card numbers can no longer be exported from QuickBooks 2008. If you choose to export credit cards to the AccessBooks database, only the last four digits will be exported with all other numbers being X’d out i.e. xxxxxxxxxxxx1234.

3.70 out of 5

10 reviews for AccessBooks RealTime

Add Review  If you leave a review we will send you a 5% off coupon. We love feedback.

  1. tech2
    1 out of 5

    (verified owner):

    I purchased this software and have yet to get it installed. I receive a cabinet error on three different computers and the installer does not work. Cannot reach anyone to get the software I paid for unless I pay for support.

  2. broc.seib
    2 out of 5


    I can’t get this to install. I get an error saying IsLicense30.dll failed to register. HRESULT -2147024770
    (screenshot here: )

  3. senthii_p
    3 out of 5


    This version of the software does not install… I have tried many a times but still have not been able to install it. I am afraid that a 3 star rating right now until this issue has been resolved.

    Please Advice!!!


  4. hank
    5 out of 5


    We downloaded the trial version of ABRT and finished the sync with SQL server in just a few click. This also included a scheduler which is perfect for our needs. Thanks for all the developers making this charming tools, its really ease of use, and user-friendly
    We will buy the subscription soon after manger approval.

  5. jerryg
    1 out of 5


    This version of the software does not install… we have done everything as directed in the FAQ’s and still have not been able to install it. I am afraid that a 1 star rating right now is all you deserve until this issue has been resolved.

    “lsLicense30.dll failed to register” during installation

    We’ve seen this error a few times and are working with the developers of our third-party license control to mitigate it but in the mean time the best solution we’ve seen is temporarily lower or disable User Access Control in Windows during the installation. Once the application is installed and all components registered, it’s perfectly fine to reset UAC to its previous level.

    • Synergration


      Jerry, we’ve come across this in a select few cases. We have pending update to our registration control that should remedy this situation however we’re also urging customers to consider our OpenSync application as it stands to supplant AccessBooks RealTime in the near future as it not only replicates but far exceeds the ABRT functionality set. For the time being, we’re also honoring ABRT prices for any interested parties. If you have any questions, please contact us at

  6. Russ Morefield
    5 out of 5


    We are using Enterprise 14 and AccessBooks RT works like a charm for us.

  7. support
    5 out of 5


    We’re using ABRT since 2005. We were looking for tool allowing export QB data to MS SQL Server, so we can provide custom complicated reporting to our clients online. Command line support was another requirement, so synchronization can be scheduled without user interaction and with multiple QB files. We found ABRT as perfect match. Over past 9 years of using ABRT we have no problems with it. Currently we’re maintaining multiple MS SQL Server databases with ABRT scheduled daily synchronizations plus manual updates as needed. Our QB files are large and transactions to be updated are big as well and ABRT handles it nicely. In our perspective, the best feature of the product is managing Database connection failure during synchronization. We don’t have to worry about missing/partial data in Database. If connection drops, ABRT synchronizes everything properly (no duplication, no corrupted data, etc) on next run. Overall, great product. Thank you!

  8. Tiffany
    5 out of 5

    (verified owner):

    We are performing a data migration from QuickBooks to another system and there is some information in QuickBooks that simply cannot be shown in a report through QuickBooks, such as which bills or invoices a payment was applied to. This product solved our problem by allowing us to directly access the data, including relationships, so we could create our own reports with no limitation. It’s great having this much access to the behind the scenes data.

  9. Bernie Lutz
    5 out of 5

    (verified owner):

    I have been using AccessBooks RealTime for many years assisting other QuickBooks customers with application and report development. AccessBooks RealTime drastically reduces development time due to a very efficient and fast transfer from QuickBooks into the AccessBooks RealTime database. Besides great products, Synergration has top notch customer service and support. Keep up the great work and thank you!!

    Bernie Lutz

  10. Nick Hopper
    5 out of 5

    (verified owner):

    We are using the pro version and installing and configuring the software was really easy. The software does exactly what is says with no issues. Having Quickbooks tables available in an SQL database made integration with our other internal systems a breeze.

Add a review