大sql导致访问崩溃

br /> FROM APPLICATION_ACES， [MS Access; DATABASE = D：\ Dossiers courants \ Projets\Absco\Absco AAIA DB \ACES \Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .BaseVehicle， [MS Access; DATABASE = D：\ Dossiers counts\Projets\Absco \ Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .Vehicle， [MS Access; DATABASE = D：\ Dossiers cou rants \ Projets\Absco \ Absco AAIA DB \ACES \Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .Make， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco\Absco AAIA DB \ACES\Vcdb\\ \\ AAIA VCdb2006 Access97 20080731.mdb] .Model， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco\Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .SubModel， [MS Access; DATABASE = D：\ Dossiers courants \ Projets \\ \\ Absco \ Absco AAIA DB \ACES \Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .DriveType， [ MS Access; DATABASE = D：\ Dossiers courants \ Projets\Absco \ Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .VehicleToBodyStyleConfig， [MS Access; DATABASE = D： \\ Dossiers courants \ Projets \ Absco \ Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .BodyStyleConfig， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco\Absco AAIA DB \ACES \ Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .BodyNumDoors， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco\Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .BodyType， [MS Access; DATABASE = D：\ Dossiers courants \ Projets\Absco\Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .VehicleToTransmission ， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco\Absco AAIA DB \ ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb]。传输， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco\Absco AAIA DB \ACES \ Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .TransmissionBase， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco\Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .TransmissionType， [MS Access; DATABASE = D：\ Dossiers courants \ Projets\Absco\Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .TransmissionNumSpeeds ， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco\Absco AAIA DB \ ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .TransmissionControlType， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco \ Absco AAIA DB \ ACES \\ Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .VehicleToEngineConfig， [MS Access; DATABASE = D：\ Dossiers courants \ Projets\Absco \ Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .EngineConfig， [MS Access; DATABASE = D：\ Dossiers courants \ Projets\Absco \ Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .EngineBase ， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco\Absco AAIA DB \ ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .EngineDesignation， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco\Absco AAIA DB \ACES \Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .Aspiration， [MS Access; DATABASE = D：\ Dossiers counts\Projets ;\\Absco \ Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .FuelType， [MS Access; DATABASE = D：\ Dossiers courants \ Projets\Absco\Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .VehicleToBrakeConfig ， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco\Absco AAIA DB \ ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .BrakeConfig， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco\Absco AAIA DB \ACES \Vcdb\AAIA VCdb2006 Access97 20080731.mdb] .BrakeType as BrakeType1， [ MS Access; DATABASE = D：\ Dossiers courants \ Projets\Absco \ Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731 .mdb] .BrakeType为 BrakeType2， [MS Access; DATABASE = D：\ Dossiers courants \ Projets\Absco \ Absco AAIA DB \ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb]。 BrakeSystem， [MS Access; DATABASE = D：\ Dossiers courants\Projets\Absco\Absco AAIA DB \\ \ nACES\Vcdb \ AAIA VCdb2006 Access97 20080731.mdb] .BrakeABS， PART， FITMENT_NOTES_LEGACY WHERE BaseVehicle.BaseVehicleID = APPLICATION_ACES.BASE_VEHICLE_ID AND Make.MakeID = BaseVehicle.MakeId AND Model.ModelID = BaseVehicle.ModelId AND Vehicle.VehicleID = APPLICATION_ACES.VEHICLE_ID AND 车辆.BaseVehicleID = BaseVehicle.BaseVehicleID AND Vehicle.SubModelId = APPLICATION_ACES.SUBMODEL_ID AND SubModel.SubModelId = Vehicle.SubModelId AND DriveType.DriveTypeID = APPLICATI ON_ACES.DRIVE_TYPE_ID AND VehicleToBodyStyleConfig.BodyStyleConfigID = APPLICATION_ACES.BODY_STYLE_CONFIG_ID AND VehicleToBodyStyleConfig.VehicleID = APPLICATION_ACES.VEHICLE_ID AND BodyStyleConfig.BodyStyleConfigID = VehicleToBodyStyleConfig.BodyStyleConfigID AND BodyNumDoors.BodyNumDoorsID = BodyStyleConfig.BodyNumDoorsID AND BodyType.BodyTypeID = BodyStyleConfig.BodyTypeID AND VehicleToTransmission.VehicleID = APPLICATION_ACES.VEHICLE_ID AND VehicleToTransmission.TransmissionID = APPLICATION_ACES.TRANSMISSION_ID AND Transmission.TransmissionID = VehicleToTransmission.TransmissionID AND TransmissionBase.TransmissionBaseID = Transmission.TransmissionBaseID AND TransmissionType.TransmissionType ID = TransmissionBase.TransmissionTypeID AND TransmissionNumSpeeds.TransmissionNumSpeedsID = TransmissionBase.TransmissionNumSpeedsID AND TransmissionControlType.TransmissionControlTypeID = TransmissionBase.TransmissionControlTypeID AND VehicleToEngineConfig.VehicleID = APPLICATION_ACES。 VEHICLE_ID AND VehicleToEngineConfig.EngineConfigID = APPLICATION_ACES.ENGINE_CONFIG_ID AND EngineConfig.EngineConfigID = VehicleToEngineConfig.EngineConfigID AND EngineBase.EngineBaseID = EngineConfig.EngineBaseID AND EngineDesignation.EngineDesignationID = EngineConfig.EngineDesignationID AND Aspiration.AspirationID = EngineConfig.AspirationID AND FuelType.FuelTypeID = EngineConfig.FuelTypeID AND Ve hicleToBrakeConfig.VehicleID = APPLICATION_ACES.VEHICLE_ID AND VehicleToBrakeConfig.BrakeConfigID = APPLICATION_ACES.BRAKE_CONFIG_ID AND BrakeConfig.BrakeConfigID = VehicleToBrakeConfig.BrakeConfigID AND BrakeType1.BrakeTypeID = BrakeConfig.FrontBrakeTypeID AND BrakeType2.BrakeTypeID = BrakeConfig.RearBrakeTypeID AND BrakeSystem.BrakeSystemID = BrakeConfig.BrakeSystemID AND BrakeABS.BrakeABSID = BrakeConfig.BrakeABSID AND PART.PART_ID = APPLICATION_ACES.PART_ID AND 对于 $ Bob Quintal PA我已经改变了我的电子邮件地址。 **发自 http：//www.te ranews.com ** I have a report SQL which have been working for a few weeks. Its largeand the target database is large. It has 59 join, and I dont thinkthere is anything I can do about this, since the DB I use has beennormalized by pros.My problem is I try to had another join to display another value, thenI get a crash report from MS-Access. Anything I can to do diagnosethis problem. My development depends on this SQL:SELECTBASE_VEHICLE_ID,VEHICLE_ID,Trim(Make.MakeName) as Make,Trim(Model.ModelName) as Model,YearID,Trim(SubModel.SubModelName) as Sub,Trim(DriveType.DriveTypeName) as DriveType,BodyNumDoors.BodyNumDoors + "DR" as Doors,Trim(BodyType.BodyTypeName) as Body,Trim(TransmissionType.TransmissionTypeName) as Trans,Trim(TransmissionNumSpeeds.TransmissionNumSpeeds) as TransSpeeds,Trim(TransmissionControlType.TransmissionControlTy peName) asTransControl,EngineBase.Liter + "L" as EngLiter,EngineBase.CC as EngCC,EngineBase.Cylinders + " CYL" as EngCyl,Trim(EngineDesignation.EngineDesignationName) as EngineName,Trim(Aspiration.AspirationName) as Aspiration,Trim(FuelType.FuelTypeName) as Fuel,BrakeType1.BrakeTypeName as FrontBrake,BrakeType2.BrakeTypeName as RearBrake,BrakeSystem.BrakeSystemName as BrakeName,BrakeABS.BrakeABSName as ABS,PART_NUMBER,FITMENT_NOTE_DESCINTORAPPORT_MAPPINGFROMAPPLICATION_ACES,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BaseVehicle,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].Vehicle,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].Make,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].Model,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].SubModel,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].DriveType,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access9720080731.mdb].VehicleToBodyStyleConfig,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BodyStyleConfig,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BodyNumDoors,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BodyType,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].VehicleToTransmission,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].Transmission,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].TransmissionBase,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].TransmissionType,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].TransmissionNumSpeeds,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access9720080731.mdb].TransmissionControlType,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].VehicleToEngineConfig,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].EngineConfig,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].EngineBase,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].EngineDesignation,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].Aspiration,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].FuelType,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].VehicleToBrakeConfig,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BrakeConfig,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BrakeType asBrakeType1,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BrakeType asBrakeType2,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BrakeSystem,[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BrakeABS,PART,FITMENT_NOTES_LEGACYWHEREBaseVehicle.BaseVehicleID = APPLICATION_ACES.BASE_VEHICLE_IDANDMake.MakeID = BaseVehicle.MakeIdANDModel.ModelID = BaseVehicle.ModelIdANDVehicle.VehicleID = APPLICATION_ACES.VEHICLE_IDANDVehicle.BaseVehicleID = BaseVehicle.BaseVehicleIDANDVehicle.SubModelId = APPLICATION_ACES.SUBMODEL_IDANDSubModel.SubModelId = Vehicle.SubModelIdANDDriveType.DriveTypeID = APPLICATION_ACES.DRIVE_TYPE_IDANDVehicleToBodyStyleConfig.BodyStyleConfigID =APPLICATION_ACES.BODY_STYLE_CONFIG_IDANDVehicleToBodyStyleConfig.VehicleID = APPLICATION_ACES.VEHICLE_IDANDBodyStyleConfig.BodyStyleConfigID =VehicleToBodyStyleConfig.BodyStyleConfigIDANDBodyNumDoors.BodyNumDoorsID = BodyStyleConfig.BodyNumDoorsIDANDBodyType.BodyTypeID = BodyStyleConfig.BodyTypeIDANDVehicleToTransmission.VehicleID = APPLICATION_ACES.VEHICLE_IDANDVehicleToTransmission.TransmissionID =APPLICATION_ACES.TRANSMISSION_IDANDTransmission.TransmissionID = VehicleToTransmission.TransmissionIDANDTransmissionBase.TransmissionBaseID =Transmission.TransmissionBaseIDANDTransmissionType.TransmissionTypeID =TransmissionBase.TransmissionTypeIDANDTransmissionNumSpeeds.TransmissionNumSpeedsID =TransmissionBase.TransmissionNumSpeedsIDANDTransmissionControlType.TransmissionControlTypeID =TransmissionBase.TransmissionControlTypeIDANDVehicleToEngineConfig.VehicleID = APPLICATION_ACES.VEHICLE_IDANDVehicleToEngineConfig.EngineConfigID =APPLICATION_ACES.ENGINE_CONFIG_IDANDEngineConfig.EngineConfigID = VehicleToEngineConfig.EngineConfigIDANDEngineBase.EngineBaseID = EngineConfig.EngineBaseIDANDEngineDesignation.EngineDesignationID =EngineConfig.EngineDesignationIDANDAspiration.AspirationID = EngineConfig.AspirationIDANDFuelType.FuelTypeID = EngineConfig.FuelTypeIDANDVehicleToBrakeConfig.VehicleID = APPLICATION_ACES.VEHICLE_IDANDVehicleToBrakeConfig.BrakeConfigID =APPLICATION_ACES.BRAKE_CONFIG_IDANDBrakeConfig.BrakeConfigID = VehicleToBrakeConfig.BrakeConfigIDANDBrakeType1.BrakeTypeID = BrakeConfig.FrontBrakeTypeIDANDBrakeType2.BrakeTypeID = BrakeConfig.RearBrakeTypeIDANDBrakeSystem.BrakeSystemID = BrakeConfig.BrakeSystemIDANDBrakeABS.BrakeABSID = BrakeConfig.BrakeABSIDANDPART.PART_ID = APPLICATION_ACES.PART_IDANDFITMENT_NOTES_LEGACY.FITMENT_NOTE_ID =APPLICATION_ACES.FITMENT_NOTE_ID; 解决方案 Another question: is there a way to turn of the questions "you areabout to insert xx records", and the other one "the table will besuppressed...". Because of the time the query needs to complete, I''min bed...Thanks.Harel <gu********@gmail.comwrote in news:b1752fc5-3616-4479-b62e- 4c**********@d45g2000hsc.googlegroups.com:Another question: is there a way to turn of the questions "you areabout to insert xx records", and the other one "the table will besuppressed...". Because of the time the query needs to complete, I''min bed...Thanks.in your previous message you said that the SQL was for a report.Reports in Access do not use MakeTable queries, so you should not getthe above messages.If you are actualy making a new table to use in the report, usingDoCmd.openQuery, prefix the statement with DoCmd.setwarnings false, andfollow it with Docmd.setwarnings true.--Bob QuintalPA is y I''ve altered my email address.** Posted from http://www.teranews.com **You need to split the SQL into several smaller queries, the firstbeing an insert query, then update the related fields using updatequeries.Also, your code is using where clauses to enforce the relationshps.That way is obsolete, use Joins instead, as they are more efficient.QHarel <gu********@gmail.comwrote innews:85c81575-13b2-4a99-9a0f- 7f**********@j22g2000hsf.googlegroups.com:I have a report SQL which have been working for a few weeks. Itslarge and the target database is large. It has 59 join, and I dontthink there is anything I can do about this, since the DB I usehas been normalized by pros.My problem is I try to had another join to display another value,then I get a crash report from MS-Access. Anything I can to dodiagnose this problem. My development depends on this SQL:SELECT BASE_VEHICLE_ID, VEHICLE_ID, Trim(Make.MakeName) as Make, Trim(Model.ModelName) as Model, YearID, Trim(SubModel.SubModelName) as Sub, Trim(DriveType.DriveTypeName) as DriveType, BodyNumDoors.BodyNumDoors + "DR" as Doors, Trim(BodyType.BodyTypeName) as Body, Trim(TransmissionType.TransmissionTypeName) as Trans, Trim(TransmissionNumSpeeds.TransmissionNumSpeeds) as TransSpeeds, Trim(TransmissionControlType.TransmissionControlTy peName) asTransControl, EngineBase.Liter + "L" as EngLiter, EngineBase.CC as EngCC, EngineBase.Cylinders + " CYL" as EngCyl, Trim(EngineDesignation.EngineDesignationName) as EngineName, Trim(Aspiration.AspirationName) as Aspiration, Trim(FuelType.FuelTypeName) as Fuel, BrakeType1.BrakeTypeName as FrontBrake, BrakeType2.BrakeTypeName as RearBrake, BrakeSystem.BrakeSystemName as BrakeName, BrakeABS.BrakeABSName as ABS, PART_NUMBER, FITMENT_NOTE_DESCINTO RAPPORT_MAPPINGFROM APPLICATION_ACES, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BaseVehicle, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].Vehicle, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].Make, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].Model, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].SubModel, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].DriveType, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access9720080731.mdb].VehicleToBodyStyleConfig, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BodyStyleConfig, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BodyNumDoors, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BodyType, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access9720080731.mdb].VehicleToTransmission, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].Transmission, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].TransmissionBase, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].TransmissionType, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access9720080731.mdb].TransmissionNumSpeeds, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access9720080731.mdb].TransmissionControlType, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access9720080731.mdb].VehicleToEngineConfig, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].EngineConfig, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].EngineBase, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].EngineDesignation, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].Aspiration, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].FuelType, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access9720080731.mdb].VehicleToBrakeConfig, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BrakeConfig, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BrakeType asBrakeType1, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BrakeType asBrakeType2, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BrakeSystem, [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BrakeABS, PART, FITMENT_NOTES_LEGACYWHERE BaseVehicle.BaseVehicleID = APPLICATION_ACES.BASE_VEHICLE_IDAND Make.MakeID = BaseVehicle.MakeIdAND Model.ModelID = BaseVehicle.ModelIdAND Vehicle.VehicleID = APPLICATION_ACES.VEHICLE_IDAND Vehicle.BaseVehicleID = BaseVehicle.BaseVehicleIDAND Vehicle.SubModelId = APPLICATION_ACES.SUBMODEL_IDAND SubModel.SubModelId = Vehicle.SubModelIdAND DriveType.DriveTypeID = APPLICATION_ACES.DRIVE_TYPE_IDAND VehicleToBodyStyleConfig.BodyStyleConfigID =APPLICATION_ACES.BODY_STYLE_CONFIG_IDAND VehicleToBodyStyleConfig.VehicleID = APPLICATION_ACES.VEHICLE_IDAND BodyStyleConfig.BodyStyleConfigID =VehicleToBodyStyleConfig.BodyStyleConfigIDAND BodyNumDoors.BodyNumDoorsID = BodyStyleConfig.BodyNumDoorsIDAND BodyType.BodyTypeID = BodyStyleConfig.BodyTypeIDAND VehicleToTransmission.VehicleID = APPLICATION_ACES.VEHICLE_IDAND VehicleToTransmission.TransmissionID =APPLICATION_ACES.TRANSMISSION_IDAND Transmission.TransmissionID = VehicleToTransmission.TransmissionIDAND TransmissionBase.TransmissionBaseID =Transmission.TransmissionBaseIDAND TransmissionType.TransmissionTypeID =TransmissionBase.TransmissionTypeIDAND TransmissionNumSpeeds.TransmissionNumSpeedsID =TransmissionBase.TransmissionNumSpeedsIDAND TransmissionControlType.TransmissionControlTypeID =TransmissionBase.TransmissionControlTypeIDAND VehicleToEngineConfig.VehicleID = APPLICATION_ACES.VEHICLE_IDAND VehicleToEngineConfig.EngineConfigID =APPLICATION_ACES.ENGINE_CONFIG_IDAND EngineConfig.EngineConfigID = VehicleToEngineConfig.EngineConfigIDAND EngineBase.EngineBaseID = EngineConfig.EngineBaseIDAND EngineDesignation.EngineDesignationID =EngineConfig.EngineDesignationIDAND Aspiration.AspirationID = EngineConfig.AspirationIDAND FuelType.FuelTypeID = EngineConfig.FuelTypeIDAND VehicleToBrakeConfig.VehicleID = APPLICATION_ACES.VEHICLE_IDAND VehicleToBrakeConfig.BrakeConfigID =APPLICATION_ACES.BRAKE_CONFIG_IDAND BrakeConfig.BrakeConfigID = VehicleToBrakeConfig.BrakeConfigIDAND BrakeType1.BrakeTypeID = BrakeConfig.FrontBrakeTypeIDAND BrakeType2.BrakeTypeID = BrakeConfig.RearBrakeTypeIDAND BrakeSystem.BrakeSystemID = BrakeConfig.BrakeSystemIDAND BrakeABS.BrakeABSID = BrakeConfig.BrakeABSIDAND PART.PART_ID = APPLICATION_ACES.PART_IDAND FITMENT_NOTES_LEGACY.FITMENT_NOTE_ID =APPLICATION_ACES.FITMENT_NOTE_ID;--Bob QuintalPA is y I''ve altered my email address.** Posted from http://www.teranews.com ** 这篇关于大sql导致访问崩溃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！