I use the below SQL code for a passthrough query and get results.

Code:
SELECT
    ID, DESCRIPTION, PRODUCT_CODE,UNIT_PRICE, USER_10, MIN_UNIT_PRICE
FROM
    PART
I cannot change this to a Make Table query so I want to use the second query to make a table, but I cannot. I get the error "Cannot open database ". It may not be a database that your application recognizes, or the file may be corrupt.". Any suggestions on how to turn this select query into a table? I basically want to get data from our server into Access to be able to run reports on.



Code:
SELECT qryGetPartsFromSystem.ID, qryGetPartsFromSystem.DESCRIPTION, qryGetPartsFromSystem.PRODUCT_CODE, qryGetPartsFromSystem.UNIT_PRICE, qryGetPartsFromSystem.MIN_UNIT_PRICE INTO [ActiveParts-System]
FROM qryGetPartsFromSystem