Re: Need help with developing Access ECO Tracking Database
Hi, I came across this site while doing research on ECO databases. I have been tasked with creating one in Access (2003) for my company. We are a small R&D company and everything is manual. I was wondering if anyone had a sample database I could use? Any help would be appreciated.
Regards,
Lisa
A lot depends on how expert you are in Access, but even more depends on what your organization has for an Engineering Change Order process and how willing they are to populate the fields when creating and revising documents each time.
Depending on your budget, there are some software solutions (electronic data management) which use either Access or SQL as the database engine. If your document list will grow much to more than a few hundred documents, most folks find SQL is a more robust database engine than Access, but many folks stick to Access to avoid the learning curve for SQL.
Your organization's task is to determine BEFORE you begin just how many fields they want to have for potential queries and file sorting of original documents and the ECOs which trigger the revised versions of those documents. Frankly, I wouldn't consider trying to keep track of ONLY ECO's when, with a little extra effort, the organization can track ALL its documents.

You may or may not have noticed this is the start of the Labor Day weekend and traffic here in the Cove traditionally drops off a lot on holiday weekends. If you don't get the answers you seek this weekend, come back Tuesday and add another post to this thread to bump it to the top of the recent post queue.