Preventative Maintenance Db or Not - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Preventative Maintenance Db or Not

Cody Millette

10 months ago

Hey all,

I have been back and forth, worked through a bunch of courses on here and I just want to know if anyone else has fully deployed an access DB for work orders or preventative maintenance DB in their place of work?

I see a demand for a system to help me manage my sustainment program within my company and I am learning from scratch while balancing my regular responsibilities I want to move away from double data entry, writing on my hard copies while in the field and then transcribing them into old excelsheets setup by the company.

Would love to be able to enter in details on a tablet as I work on equipment. Sharepoint for internet accessibility?

Thoughts? Thanks all!

Raymond Spornhauer @Reply

10 months ago

Cody

I work at a Nuclear Power Plant and it's frustrating that we use multiple separate databases that use a local script to update certain fields between them.

Maximo - Work Orders, Incident Reports
eSOMS - Tagging, LCO Tracking, Equipment Tracking
Primavera P6 - Work scheduling
Access Database - Shift turnover data and other process controls

I had created an Access Database to connect to all of these to compile the data into usable information to make our jobs easier. While the company still requires and uses those databases, I always felt it would be better to have a complete system all built into Access where everything could be tied together the way it's supposed to be.

In the past, some companies had Oracle databases that were significantly better than what's being used today.

I know Rick has a Work Order Database I started watching which was very helpful... the ABCD database is also very good so far. (very helpful techniques)
Work Orders
ABCD Database

I'd be very interested in seeing what you end up deciding.

-Raymond

	Jeff Hunker @Reply 10 months ago
Cody A PM database is actually my next project so I will follow along and add where I can. I am thankful that you posted this. Regards

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View