I recently started working on an Access 97 database for Internal Auditing (yes Access 97 my company hasn't made the switch yet). Does anyone have a copy of a database that they have implemented and would be willing to share for comparison? Same thing goes for any other databases (i.e. Docu Control, Engineering Change Control, etc...) I think I'm reinventing the wheel. :rolleyes:

I have an ECO tracking database in Access 2000.
If you think you can use it send me a PM with your email address.

Are you regulated by FDA? If you are, then your Access database needs to be validated prior to usage per QSR 820.70(i). Pls see 21 CFR Part 11 and guidance documents for more info.

needs to be validated prior to usage Have you validated one? If so, what did you have to do? I.e.: How did you validate it?

Validate an access database for internal audits !!

Whatever next ?

Thankfully I dont deal with the FDA !

I have done loads of Access databases, and it is a fantastic tool.

Unfortunately they are too big to upload however I will attempt to personally e-mail you if I can.

Unfortunately they are too big to upload however I will attempt to personally e-mail you if I can. Send to me and I can post.

I have one as well that could be modified to fit your company. Not sure how to post it here though.

I love Access as well and would be interested in any databases that could be shared.


Jerry

Hi,

This is actually my first post but I have been dipping in and out of the Cove for some time now - it is certainly one of the best forums for help and advice.

I have been using an Access database for calibration control - it's a free download from CJSystems and called cal2k. Very useful.

I have tried creating databases to cover non-conformances and customer complaints but my Access programming skills leave much to be desired. I end up exporting the data into Excel which kind of defeats the object...

I would be very interested in sharing ideas, code etc. Please keep me in the loop!

Thanks in advance

I have one as well that could be modified to fit your company. Not sure how to post it here though. See How to Attach a File to a Post in a Thread (http://elsmar.com/Forums/showthread.php?t=10668). If the file is too big (more than 3 megabytes), you can try zipping it or e-mail it to me and I'll upload it with a link to it - Just let me know what thread you want the link in.

Here's the internal audit database I am currently writing. It does function at the moment but needs a lot of clearing up as test tables and surplus queries exist. Looking at the table relationships should give you the general idea of how to get it up and running for you but at the moment I've not had time to document it. Hope it helps.

NOTE: Revised database is in post 20 of this thread.

Marc,

Can you zip that? I tried clicking on it, but a strange thing happened. It tried to open it (as text) and I got a stream of data.

Did that happen to anyone else?

FDA verification and validation compliance isn't really that bad. To verify it, document it's intended purpose and verify that it's design meets that purpose. To validate it, make a list of the expected inputs/outputs and validate that what is supposed to happen actually does. Doing these 2 things should satisfy your FDA auditor.

The FDA did publish a "guidance" several years ago, but I can't recall whether "guidance" means you can interpret it as a suggested course of action or a required course of action. I think it was "suggested".

Marc,

Can you zip that? I tried clicking on it, but a strange thing happened. It tried to open it (as text) and I got a stream of data.

Did that happen to anyone else?

Right click on the link to the file and select "save target as" and download it. Should solve the problem.

I'm really interested in looking at this database as I too am trying to implement an internal audit database. I got the same stream of data Marc did so I tried right clicking, save target as, and down loaded to my desk top. When I tried to open it it said 'unrecognized format'. Any suggestions? Thank you very much.

I tried to open the database as well and can't and I've tried to upload mine for people to view and can't. No idea what to do.

Right click on the link to the file and select "save target as" and download it. Should solve the problem.

OK, that worked. When I right-clicked to save, the dialog read "inter_audit.mdb.htm". I saved it anyway, then had to rename the extension. Weird - I've never seen that download behavior before.

Hello chergh,

Thanks for posting the Audit Database. My firewall won't allow me to download it though. Can you forward it in an e-mail to me, please? Thanks for the help. :rolleyes:

:topic: As an FYI - .mdb isn't a 'typical' file type for vB attachments (I had to add it). I just clarified the mime type for the file on the server and .mdb files should download normally now.

I tried to open the database as well and can't and I've tried to upload mine for people to view and can't. No idea what to do.Send it to me in an e-mail and I'll attach it. If you tried to attach it to a post and got an error message, let me know what it was. Unless it's over 3 megabytes in size, there shouldn't be a problem unless one is at a company with a very restrictive firewall.

I've done little more work on the database since last time, nothing major cleared away some obsolete forms, corrected the tab orders and added the ability to add processes for auditing from the front page. I have a load of other stuff I still intend to do.

To get started with it add your audits with the "add new process" button.

Once you have added the audits schedule them using the "audit scheduler" button. The format for the dates is "dd/mm/yy" this can be changed in the table or may change to local setting automatically.

If you find anything that doesn't work let me know.

chergh,

I can't open the database or save it any where either. Can you zip the database and send it to me at **e-mail address removed - see the user profile**.

I'd really appreciate it.

The database is at: http://Elsmar.com/pdf_files/

The file name is: inter_audit.mdb

PLEASE do NOT put e-mail addresses in posts. Folks can e-mail other members by using the blind mailer in the person's profile to touch base and set up file transfers and such.

I got it from the elsmar pdf files location and saved it to my hard drive, but am getting the same error I was before (unrecognized format). I'm really disappointed as I was really interested in seeing your database with your changes. But thank you very much for posting it. I hope others have luck in being able to open it.
Thank you.

I got it from the elsmar pdf files location and saved it to my hard drive, but am getting the same error I was before (unrecognized format). I'm really disappointed as I was really interested in seeing your database with your changes. But thank you very much for posting it. I hope others have luck in being able to open it.
Thank you.
Have a look here for possible solutions:Unrecognized Database Format (http://www.datarevive.com/unrecognized-database-format.php)

That's a great site- thank you. My guess is the database was created in a newer version of Access than I have. I have 97 :(. That site says I can't make the database go forward, I can only make it go backward (does that make sense?). Thank you again for that site- I will keep that one.

That's a great site- thank you. My guess is the database was created in a newer version of Access than I have. I have 97 :(. That site says I can't make the database go forward, I can only make it go backward (does that make sense?). Thank you again for that site- I will keep that one.
You're welcome. Have a look here--you might be able to convert the database so that it's useable in 97: http://office.microsoft.com/en-us/assistance/HP051863711033.aspx

chergh and Marc,
Thanks for posting this database. I had no trouble downloading it.

It looks great! We don't use Access for anything around here -- not sure why. I have been trying to get our quality manager to let us use Access for tracking document revisions and distribution, but he's not interested. I'm thinking of showing this to him and to our quality assurance officer as an example of what the software can do, as well as an example of what people can accomplish when they take a quality standard and run with it. Nice work, chergh. :applause:

Another way around the compatability issue between Access versions is to make a new, blank database on your computer, and then try and import all of the objects (tables, queries, forms, reports, and modules) from the download into your blank database. I've had luck with this, but you may have to go into an open module and set all applicable references, for the code to all work correctly.

I've done little more work on the database since last time, nothing major cleared away some obsolete forms, corrected the tab orders and added the ability to add processes for auditing from the front page. I have a load of other stuff I still intend to do.

To get started with it add your audits with the "add new process" button.

Once you have added the audits schedule them using the "audit scheduler" button. The format for the dates is "dd/mm/yy" this can be changed in the table or may change to local setting automatically.

If you find anything that doesn't work let me know.

Chergh,

Here is my database for internal audits. I'm an Access novice but please let me know what you think.

Thanks,
Scott

Scott,

the FE and BE are in the zip file, but your FE is password protected.

The password for the protected database is "gnosis".

I wouldn't ever advise puting anything confidential into an Access database as the passwords are easy to recover.

Do you have the link for cal2k? I could not locate it anywhere on the web. Thxs!

Whats cal2k?

Someone made a post on some free calibration software to track and manage calibration activities...

Did a little bit more to the database.

The only change your likely to notice is the addition of a seperate non-conformance and corrective action module, which I've not really tested that much but it seems to work ok.

If you find anything that doesnt seem to work let me know.

Could you share your ECO tracking database in Access 2000, please?
Thanks,
Yong

Chergh - I could not get the calendar buttons to work within your Audit Database...any ideas?

:frust:

First thing you need to do is populate the table called "tbl_process_master_list" with your audit areas, you then need to use the "audit scheduler to schedule these areas for audit. Once you have done this the calendar buttons should work.

I have attached the cal2k database as requested earlier.