For about three days, I have been trying to make one simple, make table, query run properly. The query seems to run right up until few seconds or so and then it errors out with the following error message:
Once it errors out, I cannot save the query. I get the same error message. I must save the query first and then run. I have ported this query to three different servers and the result is the same. Two servers are local and one is the other at our provider in Charlotte, NC (Titan Technologies). Titan is the administrator of our JD Edwards ERP system.
All of the servers are using Microsoft Access 2003 SP3.
I suspect that the problem could be related to the fact that the result of this query will be a table with about 3 1/2 million records. Am I just asking too much of Microsoft access?
SELECT PRODDTA_F0911.* INTO [tblF0911(GDS-4160-09202012-02)]
WHERE (((PRODDTA_F0911.GLAID)="00638625") AND ((PRODDTA_F0911.GLSBLT)="W"));
I have also attempted to run the query using Microsoft SQL Server 2008 Management Studio and I cannot seem to get it to create a table. I can display the 3.5MM records but that is too many to past into an Excel file or table.
SELECT PRODDTA.F0911.* INTO [tblF0911(GDS-4160-09202012-02)]
WHERE (((PRODDTA.F0911.GLAID)='00638625') AND ((PRODDTA.F0911.GLSBLT)='W'));