POS Lite 2013. Password for QBPOS.PDB?

Nicole Attard
Nicole Attard Member Posts: 7 Novice Member Novice Member
edited October 2024 in Point of Sale
Hi all,

My partner recently started a retail store and she chose POS Lite for the POS system. I'm a DBA and would like to leverage the information contained in the POS database in order to perform some more specialised analytics. After some poking around, it would appear that QBPOS.PDB is a standard JET database. However, when I attempt to open QBPOS.PDB in Access it asks for a password. After asking my wife, she has no recollection of supplying a password as part of the system setup (performed by a reckon certified company).

Does anyone have any suggestions?

Many thanks.

Comments

  • Mirko
    Mirko Reckon Alumni Posts: 1,116 Former Reckon Staff Member Former Reckon Staff
    edited November 2015
    Hey Nicole,

    To obtain access to the database you would need an SDK. Please see the below link, which also includes contact details to the relevant department. http://home.reckon.com.au/partners/ReckonPartners/OtherProfessionals/SoftwareDevelopment.aspx

    thanks,
    Mirko

  • Nicole Attard
    Nicole Attard Member Posts: 7 Novice Member Novice Member
    edited July 2016
    Thanks very much Mirko.

    I guess I could pay $499 in order to access my own data, stored in a product I already paid for....or I could download a microsoft access password recovery tool for free, and find the password.

    I took option B, but it's nice to know about the SDK.
  • Jason Hollis
    Jason Hollis Reckon Alumni Posts: 415 Former Reckon Staff Member Former Reckon Staff
    edited September 2020
    I use POS Enterprise which runs on MS SQL Server Express - far better to work with, manipulate (add attributes etc..) and report on than old school JET.

    Furthermore, Reckon Accounts is a better DB to report on as POS does not hold all of the relevant relations to run comprehensive analytics. And guess what, the QODBC driver is now free in Pro and above. 

    I am sure once you get into the data you will realise that POS is only an interface, and the numbers worth running for business (not just sales) analytics are in Accounts.
  • Nicole Attard
    Nicole Attard Member Posts: 7 Novice Member Novice Member
    edited July 2016
    Thanks for the information Jason, much appreciated.

    I spent last night going through the POS information and building a few reports that I publish to an internal website, I'm a very graphical kind of person! The business has only been running for 10 days so it's not very exciting information yet :)

    I will definitely take a look at Accounts as well.
This discussion has been closed.

Categories