I had a similar story when I watched an employee (report, copy, paste, edit)^12 (repeated steps over and over). I showed her a little Access ad-hoc query tool connected to her SQL database that provided the same functionality in minutes. She said I had just eliminated her position. I knew her supervisor and assured her that Jack had lots of tasks to keep her busy. It's nice working for a company that has 100s of manufacturing facilities worldwide that can utilize the same applications.
Duane Hookom
MS Access MVP
### posting from the new Outlook.com interface ###
> To: MS_Access_Professionals@yahoogroups.com
> From: wrmosca@comcast.net
> Date: Wed, 1 Aug 2012 17:44:28 +0000
> Subject: Re: [MS_AccessPros] docmd.Rename question
>
> Jim
>
> Interesting! When I first came to my current employer it was as a consultant. The financial reportng system I mentioned was a fiscal period thing that had to be processed each month. The woman who did the processing used an Access 2.0 database that imported flat files that were actually COBOL reports with headers and page numbers and other garbage. Luckily, Access will not roll back an import if some of the rows are bad.
>
> It took her 12 hours and constant baby-sitting the database; clicking this button and that button, cleaning up the data, manually entering some data. There are more than 20 imports to run.
>
> I redesigned the entire thing in about one month and spent another 5 months adding more features. When it went live I showed her how to run the processing. Pick the month; click a button. It took 10 minutes to run. She started crying. I thought "Oh, my God. She's going to get laid off!" But they were tears of joy. She said she hated monthly processing because it made all of her other work have to wait.
>
> The IT department offered me a permanent job which I graciously accepted. Seems that that application had very high importance.
>
> Bill
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar