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 Question
Did 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

Avatar of alevin16
alevin16Flag for United States of America asked on
Microsoft AccessMicrosoft SQL Server
6 Comments1 Solution175 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
Avatar of PatHartman
Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answers