I have a report SQL which have been working for a few weeks. Its large
and the target database is large. It has 59 join, and I dont think
there is anything I can do about this, since the DB I use has 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 do diagnose
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) as
TransControl,
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_DESC
INTO
RAPPORT_MAPPING
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 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 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].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 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 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 as
BrakeType1,
[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB
\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BrakeType as
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
\ACES\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
Vehicle.BaseVehicleID = BaseVehicle.BaseVehicleID
AND
Vehicle.SubModelId = APPLICATION_ACES.SUBMODEL_ID
AND
SubModel.SubModelId = Vehicle.SubModelId
AND
DriveType.DriveTypeID = APPLICATION_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.TransmissionTypeID =
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
VehicleToBrakeConfig.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
FITMENT_NOTES_LEGACY.FITMENT_NOTE_ID =
APPLICATION_ACES.FITMENT_NOTE_ID
;
11  2359 
Another question: is there a way to turn of the questions "you are
about to insert xx records", and the other one "the table will be
suppressed...". Because of the time the query needs to complete, I'm
in 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 are
about to insert xx records", and the other one "the table will be
suppressed...". Because of the time the query needs to complete, I'm
in 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 get
the above messages.
If you are actualy making a new table to use in the report, using
DoCmd.openQuery, prefix the statement with DoCmd.setwarnings false, and
follow it with Docmd.setwarnings true.
--
Bob Quintal
PA 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 first
being an insert query, then update the related fields using update
queries.
Also, your code is using where clauses to enforce the relationshps.
That way is obsolete, use Joins instead, as they are more efficient.
Q
Harel <gu********@gmail.comwrote in
news:85c81575-13b2-4a99-9a0f- 7f**********@j22g2000hsf.googlegroups.co
m:
I have a report SQL which have been working for a few weeks. Its
large and the target database is large. It has 59 join, and I dont
think there is anything I can do about this, since the DB I use
has 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 do
diagnose 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) as
TransControl,
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_DESC
INTO
RAPPORT_MAPPING
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 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 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].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 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 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 as
BrakeType1,
[MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco
AAIA DB
\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BrakeType as
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
\ACES\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
Vehicle.BaseVehicleID = BaseVehicle.BaseVehicleID
AND
Vehicle.SubModelId = APPLICATION_ACES.SUBMODEL_ID
AND
SubModel.SubModelId = Vehicle.SubModelId
AND
DriveType.DriveTypeID = APPLICATION_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.TransmissionTypeID =
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
VehicleToBrakeConfig.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
FITMENT_NOTES_LEGACY.FITMENT_NOTE_ID =
APPLICATION_ACES.FITMENT_NOTE_ID
;
--
Bob Quintal
PA is y I've altered my email address.
** Posted from http://www.teranews.com **
Have you thought about a career as a comedy writer?
On Aug 24, 9:24*am, Harel <guyhare...@gmail.comwrote:
I have a report SQL which have been working for a few weeks. Its large
and the target database is large. It has 59 join, and I dont think
there is anything I can do about this, since the DB I use has 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 do diagnose
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) as
TransControl,
* 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_DESC
INTO
* RAPPORT_MAPPING
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 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 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].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 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 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 as
BrakeType1,
* [MS Access;DATABASE=D:\Dossiers courants\Projets\Absco\Absco AAIA DB
\ACES\Vcdb\AAIA VCdb2006 Access97 20080731.mdb].BrakeType as
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
\ACES\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
* Vehicle.BaseVehicleID = BaseVehicle.BaseVehicleID
AND
* Vehicle.SubModelId = APPLICATION_ACES.SUBMODEL_ID
AND
* SubModel.SubModelId = Vehicle.SubModelId
AND
* DriveType.DriveTypeID = APPLICATION_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.TransmissionTypeID =
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
* VehicleToBrakeConfig.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
* FITMENT_NOTES_LEGACY.FITMENT_NOTE_ID =
APPLICATION_ACES.FITMENT_NOTE_ID
;
On 24 août, 12:58, lyle fairfield <lyle.fairfi...@gmail.comwrote:
Have you thought about a career as a comedy writer?
What is it you dont like about the post?
On Aug 24, 2:15*pm, Harel <guyhare...@gmail.comwrote:
On 24 août, 12:58, lyle fairfield <lyle.fairfi...@gmail.comwrote:
Have you thought about a career as a comedy writer?
What is it you dont like about the post?
I love the post. I also love Lucy, Seinfeld, Jackie, Red and Carole.
I love the post. I also love Lucy, Seinfeld, Jackie, Red and Carole.
Ok then. I prefer "tragedy" anyway...
Harel <gu********@gmail.comwrote in news:141cc46b-faa8-404f-8c74- 15**********@k37g2000hsf.googlegroups.com:
>I love the post. I also love Lucy, Seinfeld, Jackie, Red and Carole.
Ok then. I prefer "tragedy" anyway...
The tragedy is in the way you wrote the SQL. :-)
--
Bob Quintal
PA is y I've altered my email address.
** Posted from http://www.teranews.com **
Bob Quintal <rq******@sPAmpatico.cawrote in
news:Xn**********************@66.175.223.2:
Also, your code is using where clauses to enforce the
relationshps. That way is obsolete, use Joins instead, as they are
more efficient.
That depends on the circumstances. Most WHERE clauses are optimized
by the Jet query optimizer exactly the same way as a join.
But not all of them.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
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 db].APPLICATION_ACES, [connect string
for this db].PART, [connect string for this
db].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
courants\Projets\Absco\Absco AAIA DB\ACES\Vcdb\AAIA 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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Stuart P |
last post by:
Hello,
I am making my first real game in C++ and there is a problem with the class
used to contain a level. The level::load(filename) function gives an Access
Violation error when trying to...
|
by: Peter Frost |
last post by:
Please help
I don't know if this is possible but what I would really like to do is
to use On Error Goto to capture the code that is being executed when
an error occurs.
Any help would be much...
|
by: Jamma |
last post by:
Hello,
I have an Access 2000 file working on XP machines and a NT network.
The files are split and 95% of the time all is well and stable. The
main issue arises when the app prints,a novell...
|
by: russ |
last post by:
Hi
I need some advice about ms-access limitations. i have some databases
written by others i have been working with that keeps crashing.
different on different computers, so it sounds like a...
|
by: deko |
last post by:
Do I get more scalability if I split my database? The way I calculate
things now, I'll be lucky to get 100,000 records in my Access 2003 mdb.
Here some math:
Max mdb/mde size = 2000 x 1024 =...
| | |
by: Sarah |
last post by:
I need to access some data on a server. I can access it directly using UNC
(i.e. \\ComputerName\ShareName\Path\FileName) or using a mapped network
drive resource (S:\Path\FileName).
Here is my...
|
by: bennett |
last post by:
I have a table with about 100,000 records whose description is:
+-----------------------+----------------------+------+-----+---------+----------------+
| Field | Type ...
|
by: Mell via AccessMonster.com |
last post by:
Is there a way to find out where an application was created from?
i.e. - work or home
i.e. - if application sits on a (work) server/network, the IT people know the
application is sitting...
|
by: nmehring |
last post by:
I have an MFC app with 2000 users. I have one user that experiences a
crash in our software anywhere from 1 to 5 times a week when opening a
particular module. No other users have reported this...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
