Access crash caused by large sql

I don't understand why you're specifying the path for all but three
tables, when you really need to do it for the three. Seems to me it
would be much simpler to do this:

FROM [connect string for this Database].APPLICATION_ACES, [connect string
for this Database].PART, [connect string for this
Database].FITMENT_NOTES_LEGACY, BaseVehicle, Vehicle, Make, Model,
SubModel, DriveType, VehicleToBodyStyleConfig, BodyStyleConfig,
BodyNumDoors, BodyType, VehicleToTransmission, Transmission,
TransmissionBase, TransmissionType, TransmissionNumSpeeds,
TransmissionControlType, VehicleToEngineConfig, EngineConfig,
EngineBase, EngineDesignation, Aspiration, FuelType,
VehicleToBrakeConfig, BrakeConfig, BrakeType as BrakeType1,
BrakeType as BrakeType2, BrakeSystem, BrakeABS IN 'D:\Dossiers
courantsProjetsAbscoAbsco AAIA DatabaseACESVcdbAAIA VCdb2006
Access97 20080731.mdb'

Since all your tables but 3 of them are in the same MDB, it makes
more sense to specify the connect string for those THREE and use IN
to specify the MDB for all the other tables.

From there, you might be able to resolve your issue and use joins in
place of a WHERE clause.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

On database window
Click "Queries" then click " Create query in Design view "
And start from the beginning.
Create your first query then save it.
Click again " Create query in Design view "
Create your second - if necessary onto the first one.
Basing or joining other queries your previously created should be
pencilled in your case.
How many queries ? Well, looking at your sql I'd say more than one
surely.
I mean if the word of "diagnose " is creating some difficulty.

kind rgds