troubleshooting Question

Stored Procedures - Microsoft Access

Avatar of Eileen Murphy
Eileen MurphyFlag for United States of America asked on
Microsoft SQL ServerSQL
4 Comments2 Solutions40 ViewsLast Modified:
SQL Stored Procedure Question - From within an Access application -- sending changes to the SQL Server via a stored procedure call ----

Is it better to update one field at a time -- or to send all changes made on an unbound form in one function to the server?

Attached is an example of the Stored Procedure.

Client is experiencing awful bottlenecks and locking - ODBC timeouts, etc. I am in the process of rewriting the application in the trouble-spots but want to get some advise on how best to do this. I have used almost the exact stored procedure as the attached for other client apps with no issues -- but in this client's environment it locks everyone up - everything locks their system up.

Some forms have dozens of hidden subforms with links back to the customer table -- being eliminated -- and all their combo boxes (to select a customer) is another link back to the customer table -- I am replacing those with passthrough queries, etc.
Senior Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros