Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an Access 03 program with a bunch of VBA code that is in use and the end user wants new functionality. I am finding it very difficult to add new functionality because my brain wants to use the most recent .NET technologies and VBA is not recent at all.

How should I go about "rolling back" technologies in my head to keep my frustration levels to a minimum?

Also my boss said it wasn't in the budget to rewrite the project from access and vba to some sort of form and SQL combo (which I could probably pound out in a few days, which is the same amount of time that I feel that it will take me to look up and implement in the old system).

share|improve this question

closed as off-topic by durron597, GlenH7, Ixrec, MichaelT, Snowman May 20 '15 at 1:17

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking career or education advice are off topic on Programmers. They are only meaningful to the asker and do not generate lasting value for the broader programming community. Furthermore, in most cases, any answer is going to be a subjective opinion that may not take into account all the nuances of a (your) particular circumstance." – durron597, GlenH7, Ixrec, Community, Snowman
If this question can be reworded to fit the rules in the help center, please edit the question.

Sounds like you have plans for the weekend. – JeffO Dec 14 '10 at 21:21
Personally I'd tell my boss something along the lines of "I forget most of that, and would have to take [x] days to re-acquaint myself with the technologies." ie. "I don't want to." Eventually, the salespeople have to learn to say "No, we don't support that anymore." – Steve Evers Dec 14 '10 at 22:51
up vote 5 down vote accepted

Consider it an exercise in mental flexibility. Appreciate the chance to temporarily lower your standards, so when you come back to the most recent .net, it will be like paradise to you.

share|improve this answer

You should be able to take satisfaction and professional pride in figuring out the existing code base, adding your new functionality in a way that doesn't make the situations worse, and not breaking the existing functionality. I have to do this all the time, back and forth between recent technology and old technology. I've always taken satisfaction out of being able to do this well.

share|improve this answer

Turn on the Nirvana, roll up your flannel shirt's sleeves, stroke your beard and just get down to work.

Kidding aside, I find it somewhat unpleasant to "roll back" from VS 2010 to Visual Studio for Applications. BUT, I find it a fulfilling challenge to employ methodologies such as formal Design Patterns, Inversion of Control, automated unit testing, etc. in the older environment.

share|improve this answer
+1 for just thinking about introducing unit testing in Access 2003. That is a whole world of hurt (to coin a phrase). – Gary Rowe Dec 15 '10 at 0:33

Apart from imagining that you are in year 1997 and just getting your hands dirty with VBA, I don't see any other way you could fix this.

share|improve this answer

If you're good at what you do and it's your professional opinion that it would be more cost-effective to re-do it in .NET instead of struggle with VBA, then your boss should take that seriously. If they don't then I recommend you find a new, competent boss somewhere else :)

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.