Many moons ago I did a very simple web site for an intranet using SQL Server and FrontPage. I used VBScript and ADO to do the heavy lifting. Today I would have no idea how to do what I did. I'm not telling anyone in our department that Access 2013 has a web app capability. It's far to limited for what is usually expected. I, too, am going off to do other things. I'm trying to keep my hand in the Access world, but my main work is now in Epic, a Caché database electronic medical record software. It's the biggest EMR company in the world. A huge undertaking. It will take us a good 18 months to convert.
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :
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 3rd 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
Microsoft Office Access MVP
My nothing-to-do-with-Access blog
---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.
<clipped>
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.
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.
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (14) |
Tidak ada komentar:
Posting Komentar