POS Lite 2013. Password for QBPOS.PDB?

Options
Nicole Attard
Nicole Attard Member Posts: 7 ✭
edited September 2020 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 Alumni Posts: 1,256 ✭✭
    edited November 2015
    Options
    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 ✭
    edited July 2016
    Options
    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 Alumni Posts: 516 Reckon Staff
    edited September 2020
    Options
    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 ✭
    edited July 2016
    Options
    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.

Categories