Jump to content

  • Quick Navigation
Photo
- - - - -

Created my own HACCP Risk assessment program with MS Access


  • You cannot start a new topic
  • Please log in to reply
39 replies to this topic

#26 Charles.C

Charles.C

    Grade - FIFSQN

  • IFSQN Moderator
  • 13,440 posts
  • 3675 thanks
397
Excellent

  • Earth
    Earth
  • Gender:Male
  • Interests:SF
    TV
    Movies

Posted 13 July 2016 - 12:46 PM

Sorry I cant convert the database to 2003. I tried but I use objects from 2007 and up.

 

Hi Dongilles,

 

No problem. i shall probably be obliged to upgrade at some time. Thanks for trying.

 

From the Word documents, looks like a hybridisation of (Codex + ISO).


  • 0

Kind Regards,

 

Charles.C


#27 Gilles

Gilles

    Grade - MIFSQN

  • IFSQN Member
  • 64 posts
  • 10 thanks
0
Neutral

  • Earth
    Earth
  • Gender:Male

Posted 14 July 2016 - 12:50 PM

Hello all,

 

I update the database in Dropbox. the new version is 0.7

 

I changed the following:

  • I rebuild the database, everything is now in English so if you want to use it yourselfs its a lot easier to add something
  • Added some new CCP (OPRP) parameters to complete so everyhing the codex needs is added
  • Added a management tab so when you change something you can add that there so you always have a record of all changes
  • Tweaked some of the appearance so its easier to use

I have seen that many people have downloaded the database, I hope you all will leave some comments on what is good or what needs to bo changed.

 

The new version can be found at: https://www.dropbox....4NYruR_uBa?dl=0


  • 0

#28 Charles.C

Charles.C

    Grade - FIFSQN

  • IFSQN Moderator
  • 13,440 posts
  • 3675 thanks
397
Excellent

  • Earth
    Earth
  • Gender:Male
  • Interests:SF
    TV
    Movies

Posted 14 July 2016 - 01:10 PM

Hi Dongilles,

 

Afaik, Codex is 100% unaware/unrelated to OPRP ?.

 

This is an ISO invention. Or, IMO, more of an ISO abomination.

 

But perhaps something has recently changed within Codex-HACCP.


  • 0

Kind Regards,

 

Charles.C


#29 Gilles

Gilles

    Grade - MIFSQN

  • IFSQN Member
  • 64 posts
  • 10 thanks
0
Neutral

  • Earth
    Earth
  • Gender:Male

Posted 14 July 2016 - 01:23 PM

True the codex and OPRP are unrelated.

Personally I find OPRP usefull for some hazards that need extra attention but is not a CCP.

Also in my experience auditors like to see them. That is why I incorperated them into the database.

 

FSSC22000 also works with OPRP's


  • 0

#30 Gilles

Gilles

    Grade - MIFSQN

  • IFSQN Member
  • 64 posts
  • 10 thanks
0
Neutral

  • Earth
    Earth
  • Gender:Male

Posted 21 July 2016 - 02:02 PM

Just had the first audit (BRC) with my own system and the auditor was very pleased with what he saw. So I am very pleased with this!

 

I am also a bit sad, eventhough the database has been downloaded several times no comments on what works or what does not work... I hoped for at least some feedback.

 

(sorry charles not counting your feedback because you can not open the file)


  • 0

#31 mgourley

mgourley

    Grade - PIFSQN

  • IFSQN Principal
  • 888 posts
  • 733 thanks
96
Excellent

  • United States
    United States
  • Gender:Male
  • Location:Plant City, FL
  • Interests:Cooking, golf, firearms, food safety and sanitation.

Posted 21 July 2016 - 05:36 PM

I have downloaded it and played around some. 

Been busy here with audits and the like so have not had sufficient time to provide any constructive feedback.

 

I'll get to it shortly.

 

Marshall


  • 0

#32 SangLuu

SangLuu

    Grade - Active

  • IFSQN Associate
  • 1 posts
  • 0 thanks
0
Neutral

  • United States
    United States

Posted 11 October 2017 - 02:13 AM

Hello, 

 

I know that this has thread has not been touched for a year, but I am really hoping that this is still available.  The links on this page appear to be dead.  Would anyone happen to have this file available? 


  • 0

#33 Pemy

Pemy

    Grade - Active

  • IFSQN Active
  • 1 posts
  • 0 thanks
0
Neutral

  • Serbia
    Serbia

Posted 01 April 2018 - 05:36 PM

Hello all,

 

I update the database in Dropbox. the new version is 0.7

 

I changed the following:

  • I rebuild the database, everything is now in English so if you want to use it yourselfs its a lot easier to add something
  • Added some new CCP (OPRP) parameters to complete so everyhing the codex needs is added
  • Added a management tab so when you change something you can add that there so you always have a record of all changes
  • Tweaked some of the appearance so its easier to use

I have seen that many people have downloaded the database, I hope you all will leave some comments on what is good or what needs to bo changed.

 

The new version can be found at: https://www.dropbox....4NYruR_uBa?dl=0

Could you be so kind to add new dropbox link, this link is expired.

Thank's in advance.


  • 0

#34 chrcia

chrcia

    Grade - AIFSQN

  • IFSQN Associate
  • 35 posts
  • 9 thanks
2
Neutral

  • United States
    United States
  • Gender:Male

Posted 02 April 2018 - 10:19 AM

Add me to the list please


  • 0

#35 chrcia

chrcia

    Grade - AIFSQN

  • IFSQN Associate
  • 35 posts
  • 9 thanks
2
Neutral

  • United States
    United States
  • Gender:Male

Posted 02 April 2018 - 10:23 AM

I hae tried to open the drop box link several times I get an error message


  • 0

#36 yabuazza

yabuazza

    Grade - Active

  • IFSQN Active
  • 1 posts
  • 0 thanks
0
Neutral

  • United Kingdom
    United Kingdom

Posted 02 April 2018 - 11:09 AM

please be my guest 


  • 0

#37 Scampi

Scampi

    Grade - FIFSQN

  • IFSQN Fellow
  • 1,097 posts
  • 307 thanks
39
Excellent

  • Canada
    Canada
  • Gender:Not Telling

Posted 03 April 2018 - 02:12 PM

This used to be available in excel format and sadly I've changed companies and did not bring it with me.  Here is a link to the CFIA hazard database.  Its is a wee bit clunky at first but IMEX is worth it. It is a very broad database that can be filtered for your process.

 

NOTE; there may be some referances to the FSEP manual within the database see link below

http://www.inspectio...9/1345821716482


  • 0

#38 twinkle

twinkle

    Grade - Active

  • IFSQN Active
  • 12 posts
  • 0 thanks
0
Neutral

  • South Africa
    South Africa

Posted 07 May 2018 - 08:43 AM

Hello all,

 

Sorry for the delay, Simon and I had several idea's how to do this, sadly they did not work but now we have a solution.

 

The latest version is downloadable through the following link:

https://www.dropbox....4NYruR_uBa?dl=0

 

There are 4 documents:

MyQRA procedure, this is the procedure how the risk assessment works

MyQRA Manual, this is a simple (ugly) manual for how to use the database

MyRA: Is the actual database

MyRA_back-up: This document that access automaticly makes so you do not need this.

 

 

Note, this is just an alpha build of my database, there may be some problems. Also this manual does not go in the workings of MS Access, if you want to use this alpha version you need to have some basic understanding of Access.

 

The documents in the dropbox link will be update when needed so they will always be the latest version of the database.

Currently the database is at version 0.6

 

So please check it out and leave comments here. If there are any questions please let me know and hopefully you all can make good use of the programm.

Hi

 

Seems very interesting, is there a new link available for this?


  • 0

#39 chrcia

chrcia

    Grade - AIFSQN

  • IFSQN Associate
  • 35 posts
  • 9 thanks
2
Neutral

  • United States
    United States
  • Gender:Male

Posted 07 May 2018 - 09:55 AM

Add me to the list please I am very interested


  • 0

#40 Charles.C

Charles.C

    Grade - FIFSQN

  • IFSQN Moderator
  • 13,440 posts
  • 3675 thanks
397
Excellent

  • Earth
    Earth
  • Gender:Male
  • Interests:SF
    TV
    Movies

Posted 07 May 2018 - 12:43 PM

Add me to the list please I am very interested

 

I searched my archives and I think the file below derived from the dropbox link.

 

Anyway you can have a play. :smile:

 

Attached File  IFSQN Dongilles.zip   1.35MB   16 downloads


  • 0

Kind Regards,

 

Charles.C





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users