We help IT Professionals succeed at work.
Get Started

Conversion from Access Jet to SQL Back-end

267 Views
Last Modified: 2012-05-11
I recently posted a request for assistance with converting a client from the Jet Back-end to SQL Server 2008 -- your responses were extremely helpful. BUT now that I've implemented the recommended changes have noticed significant delays during testing -- after users make record selections from combo-boxes - as well as during form loading. I could really use some help to know where to look for possible reasons for this. The application loads up fine and some forms are okay -- but the most important forms of course are creating the problems.

There are some calculations that need to be performed OnCurrent -- to calculate # of days out --and to update some other fields with results based on the days out  x a factor -- this function may be the culprit. I don't know where else to put this code. It's pretty important. I don't know how to push some of the computing to the server -- if that would help... I've stepped through the code and of course when I do that I don't see any snags anywhere...

Any help would be appreciated. Best, Eileen
Comment
Watch Question
Software Architect
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 2 Answers and 7 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE