Query of large linked table

[ipr1]

I have a linked table with about 160K records in it. When I execute a select query, the query returns the desired results. However, we I change the select to a make table query, I get a message that says I have an invalid argument.

Any suggestions about a cure? (No rush - I have some time to resolve this problem). Thanks in advance for your help.

 

[dcx693]

Can you post the make table query SQL?

 

[ipr1]

Here you go:


SELECT TRC_LOAN.ICU, TRC_LOAN.PLAN, TRC_LOAN.LOAN_ID, TRC_LOAN.PARTICIPANT, TRC_LOAN.ORIGINAL_AMT, TRC_LOAN.START_DATE, TRC_LOAN.INTEREST_RATE, TRC_LOAN.PAYMENT_AMT, TRC_LOAN.PAYMENT_FREQ, TRC_LOAN.PAYMENT_CNT, TRC_LOAN.PARTICIPANT_TAX_ID INTO Loans_Refresh
FROM TRC_LOAN;


Thanks for your assistance.

 

[dcx693]

Well, nothing weird-looking in there. Is this a "normal" linked table, or is it an ODBC table?

 

[ipr1]

ODBC

What is really wierd is the fact that a select query works and a make table does not - I just cannot see what is wrong.

 

[dcx693]

I don't know what to suggest, though if you run out of options, use DDL and the CREATE TABLE statement to make a new table and the INSERT INTO statement to add records to the new table. I know, lame, but it's a workaround if you don't find a solution.

 

[Torq]

ipr1 - I have just this afternoon have had exactly the same error. I have a large (approx 1.7 million line) linked ODBC table. I had a Make Table query running across it to extract records within a certain date range. I've come back from lunch and now everytime I try to run the query I get the "invalid argument" error.

I have investigated a little and I can use select queries happily on the linked table, and I can use make table queries in other databases. I can't use make table queries across any of the other tables in the affected database, but I can on a quick mock up table I created with just random data in.

It defies logic, why did it suddenly stop working!

Any ideas?

 

[BigToad]

microsoft link about problem

Hi,

sure you've sorted this by now but just thought i'd post this for future refence:

http://support.microsoft.com/default.aspx?scid=kb;en-us;835416

I had the same problem but I ran a compact and repairr and it reduced the database size and then the make table worked.