troubleshooting Question

I am having an ODBC timeout issue with an Access Frontend

Avatar of alevin16
alevin16Flag for United States of America asked on
Microsoft AccessMicrosoft SQL Server
6 Comments2 Solutions175 ViewsLast Modified:
Hello All

I am having an odd thing happen.  I have a form in Access that runs 2 append queries.  One will append fields on the form to one table and the other will append different fields to a different table.  Neither table is linked in any way to each other.  The only thing they share is the same key field (basically I originally had all the fields in one table but it started to get hard to deal with so I just split it into 2 tables).

The append queries each add about 20 fields to each table (one record).  The first append query runs fine, but then I get a timeout on the second one (I have attached the error).

This only started happening today.  Up until now all was fine.

The tables have a little over 11000 records.  There are about 20 people in the company but only 2 people at most use that form that runs those 2 append queries.

Here is the Append Query that is failing

INSERT INTO QuoteStatusAddendum ( TrueID, [Standard Order], [ARC Type], [ARC Wording], QuoteItem, [Discount Type], [Main Or Copy], [Raman Notes] )
SELECT [Forms]![Popup ARC]![txtIDBuilder] AS Expr1, [Forms]![Popup ARC]![chkStandardOrder] AS Expr2, [Forms]![Popup ARC]![cboProductID] AS Expr3, [Forms]![Popup ARC]![txtARCDetails] AS Expr4, [Forms]![Popup ARC]![cboQuoteItemName] AS Expr5, "None" AS Expr6, "Main" AS Expr7, [Forms]![Popup ARC]![txtIDBuilder] AS Expr8;

Any insights would be much appreciated.

Thanks!
ODBC-Error.jpg
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 6 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 6 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