[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 480
  • Last Modified:

I am looking for a Basic Point of Sale (POS) and Inventory Tracking that works with MS Access 2003

I am looking for a FREE Basic Point of Sale (POS) and Inventory Tracking database that will run on MS Access 2003.  

I have office location that has a small inventory of Patient Resale Items and am looking for an easy way for the office to manage their sales and inventory.  When I say small inventory, right now there are less than 100 items.

I have already searched Google and didn't come up with anything worth while.    Can anyone offer any good suggestions or possibly have a Microsoft 2003 database template that would do the job.

Thank you.
  • 5
  • 2
  • 2
  • +1
1 Solution
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
This product ...  http://www.databasecreations.com/prod_buspro.htm  ... and related products on the site have evolved over a long period of time. Cary Prague has been around since Access 1.0.  All are 'open source' ... so you can tweak as required.

I think the problem in your question is the word 'Free'.

The best of luck searching.
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Yes ... I'm always amazed that ... people are expecting to get something (that is actually useful) for free, when no doubt that 100's and 100's of hours of development time have been put into a product.  Most of these products in general are very reasonable priced anyway, and most in my mind are 'free' in that context, compared to the time it would take me to reproduce.



Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

anctechAuthor Commented:
Sorry MX,  I didn't intend to piss you off.  Basically what I was looking for is a good template to get me started in the right direction.  I haven't found a template from Microsoft pertaining to POS.  Anyway I never expected anyone to custom write a database application for me for Free.

Maybe I should remove the word free and replace it with "Open Source".  Does that make you feel better?
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Chill. I'm not pissed off, lol. It's just an observation, and a frequent occurrence.  And the good news is ... what I posted above is Open Source :-)

Check it out ...

More good news:
There are some 'templates' (of sorts) at these links, but don't recall a POS app off hand:





Jeffrey CoachmanCommented:

As you can see, we have all been down this road before.

Yes, ...there are some great "Free", "Open Source" applications out there.
Some of which rival their commercial counterparts...

*However* "Free" can also mean programs that are less then professionaly designed.
They may have little or no support
They may be basically scaled down versions of the "Pay" version

Free might be great for a simple contacts DB or something similarly basic and straightforward...

But for POS/Inventory systems (systems that may be called upon to interface with accounting and other systems), you need something *Solid*.
Remember that most of these systems separate POS functions from Inventory functions, making your request of a "combined FREE" solution even more complex.

Access has an Inventory DB template for 2003:

But I don't know of any POS specific Access db templates...

Even if you found one, you will still have to customize both of them to work with your data.
Then you will have to "Interface" these two systems to work flawlessly together.

POS/Inventory programs are not the types of programs you may want to tackle in Access unless you *Really* know what you are doing in terms of DB design and POS/inventory theory and implementation...

My 2c...



anctechAuthor Commented:
Hi Jeff,

Thanks for your 2 cents.  I fully understand that any free Inventory or Point of Sales database application will likely not be anything spectacular, however it would have to be better than an office keeping track of inventory using a simple spreadsheet.

Inventory (less than 100 items) is the main thing right now, but if there was something available on the web that worked with MS Access 2003 that incorporated a Sales side, that would have just been icing on the cake per say.

Here is my 2 cents, FREE doesn't always mean bad or poor quality.  For example I use Mozilla Firefox and Thunderbird which are both "Free" and I beleive they are just as good as any paid Microsoft product.   There are good Free products out there, my original post was simply asking if anyone knew of any that fell into the category of Inventory/Point of Sale that would work with Access 2003.  

I would consider my self somewhere between entry level and Intermediate in regards to access programming.   If I had a good access database template to get started, I think I would be able to change it just enough to fit my needs.  

Anyway, I really can't beleive how the word Free has seemed to have ruffled so many feathers.    WOW!!!  
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
" For example I use Mozilla Firefox and Thunderbird which are both "Free" and I beleive they are just as good as any paid Microsoft product. "
Well, gee ... kind of apples and avocados ... two completely different business models and paradigms.  And Internet Explorer is free.

Nothing wrong with looking for free ... for sure. No problem here.
Jeffrey CoachmanCommented:
<FREE doesn't always mean bad or poor quality.>
I know...
I clearly stated:
<there are some great "Free", "Open Source" applications out there.
Some of which rival their commercial counterparts...>

The main issue is that we, as Experts here, have encountered so many situations where an asker will *insist* on a Free solution.
Only to post countless questions here for help with those same systems.

It happens so often that most of us immediately have the same knee-jerk reaction.

I'll give you an example:
One hot topic is always finding/displaying images in Form/Report records

MX first introduced most of us to this program:
Which is not free, ...but full featured and reasonably priced.

I also have had lots of "accepted" solutions for my simple DB:
(attached below)

Now, my solution is free and many have used it without issue.
But it is rock-bottom basic (gets and displays the image in a form or report), and I don't offer any "support" for it per se...

DB pix will let you capture from TWAIN devices, it also offers resizing and Rotation, ...etc

In many cases I post my solution along side dbpix and let the asker decide for themselves.

I never push my file as being "Just as good as Dbpix, but free", because, quite simply, it is not.

So it all depend on what you need.

Finally note that this site counts some real *Giants* in the industry among its members.
May Access experts here could certainly build thier own:
Front end Updaters
Screen resizers
Find/replace Utilities
Email systems
VBA code utilities

But yet most all of us/them will recommend existing utilities to do all of this...


...it all depends on what you need....


DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now