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
Ask a QuestionDid 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
troubleshooting Question
I am having an ODBC timeout issue with an Access Frontend
asked on
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
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
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.