troubleshooting Question

Issue when manipulating tables in Microsoft SQL 2005

Avatar of jana
janaFlag for United States of America asked on
Microsoft SQL Server.NET ProgrammingVisual Basic.NETMicrosoft SQL Server 2005SQL
16 Comments6 Solutions514 ViewsLast Modified:
We have a VB Invoice application where the detail lines are unlimited.  Up to now the max of detail lines are a bit over 700 lines.  

Users can create an invoice, save it and later on another user modifies it.  One specific invoice can be worked by at least 4 user ate different stages.  But no 2 users can work with the same invoice.  However, at least 7 users have each an invoice working with it.

The problem we have is when user are saving the invoice.

We had issues of the process stops or takes too long, but most of the times, it just get uninterrupted and the user looses their entry that can be at least 20 to 50 lines.

So we are looking for EE insight on proper process of saving so the apps stops being interrupted or takes too long.
ASKER CERTIFIED SOLUTION
David Todd
Senior Database Administrator

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

Join our community to see this answer!
Unlock 6 Answers and 16 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 6 Answers and 16 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