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;
”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
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.