How can I discourage the use of Access?
Posted
by
Greg Buehler
on Programmers
See other posts from Programmers
or by Greg Buehler
Published on 2012-11-08T05:55:31Z
Indexed on
2012/11/08
11:22 UTC
Read the original article
Hit count: 289
planning
|projects-and-solutions
Lets pretend that a very large company (revenue numbers with more than 8 figures) is looking to do a refresh on a software system, particularly the dashboard used by employees. This system was originally put together in the early 1990's to handle inventory tracking and storage across a variety of facilities (10+). Since this large company is now in the process of implementing some of these inventory processes with SAP they are in need of a major refresh.
The existing system:
- Microsoft Access project performs dashboard duties
- Unique shipping/receiving configurations at different facilities require unique forms and queries within the Access project
- Uses 3rd party libraries referenced by Access to directly interface with at control system (read: motors, conveyors, and counters)
- Individual SQL Server 2000 instances (some traces of pre-update SQL Server 6.0 documents) at each facility
The Issue:
- This system started as a home brewed inventory tracking scheme with a single internal sponsor who is still in charge of the technical direction. The original sponsor prescribing the desired deliverables that are being called for in the current RFP.
- The RFP describes a system based around a single Access project.
- Any suggestion that Access is ill suited for a project of this scope are shot down under the reasoning that "it works for the scope now".
Are there any case studies, notices, or statements that can be used to disuade this potential customer from repeating their mistake? Does Microsoft make any statements directly about when it is highly recommended to ditch Access?
© Programmers or respective owner