ACCESS FEED: RE: [MS_AccessPros] Do I really need all of these Queries?

Selasa, 25 November 2014

RE: [MS_AccessPros] Do I really need all of these Queries?

YES! I'm excited about my beginning work with corporate IT to "convert" existing systems. I get to learn new technologies, but am a bit skeptical that the asp.net world with an sql server background will be as powerful and have as much functionality with the speed as I've built here. I suspect I'll be able to demonstrate more of my worth to the corporate folks. One of the databases that was supposed to be taken over by Siemen failed. The 3^rd party team got fired and I don't know how much money they spent on that project. However, what we have still works and is fairly robust. Engineering changes drive so much of our business here. J

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, November 25, 2014 12:39 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Do I really need all of these Queries?

> they "don't support Access."

Ha-ha! When I was first hired at my present job I was told all I had to do was create a highly customized project management system in Access and then I would be doing only SQL Server DBA work since they did not support Access applications nor did they do in-house development of any kind. 12 years later I'm still developing new Access applications and adding features to existing ones I've made.

When I asked my boss about what he told me at the job interview he just said he never knew Access could do the things I've made it do. Not trying to brag. It's just that IT departments usually get stuck with amateur, badly-designed Access databases so they throw out that blanket no-support statement.

Bill

---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :

Wonderful story Bill. Unfortunately my Access competency wasn't up to speed back in the day for the work I did here so I didn't know better. Now I look at the stuff that I was complicit in in my ignorance and hope for the day when we can convert systems without such a wide impact.

I'm cleaning as I go, and I've got a new assistant here (Sheila) helping me out.

We're also moving towards getting the systems to formats where corporate IT will endorse and support since they "don't support Access."

J which is good for me cause I get to learn new skills. Studying ASP.Net technologies now.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, November 24, 2014 2:30 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Do I really need all of these Queries?

Liz

Probably every Access developer has had her share of inherited, badly designed databases. When I was an independent contractor I got tons of those. Lots of potential clients did not want to hear that I'd have to start from scratch. They thought I was trying to rip them off. Truth be told, when they insisted I modify their existing mess I politely declined. When the next 2 or 3 contractors told them the same thing I usually got called back because I was the lowest bidder. So I always loved inheriting those nightmares.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :

I didn't read all of this, but man can I identify with this. I inherited stuff that has come in very unnormalized and now too many processes and other links run off of them. I'm hoping that assistance and future conversions will eliminate the bad design of some of the stuff I deal with.

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.