How can I show changes made to a VCdb?
Open the VCdb in Access (you may need to convert the VCdb to the version of Access you are using). Create a query, go to the SQL View and paste in this query and save.
SELECT vcdbchanges.tablename, vcdbchanges.action, Make.MakeName,
Model.ModelName, BaseVehicle.YearID
FROM vcdbchanges
INNER JOIN (Model INNER JOIN
(Make INNER JOIN BaseVehicle ON Make.MakeID = BaseVehicle.MakeID)
ON Model.ModelID = BaseVehicle.ModelID)
ON vcdbchanges.id = BaseVehicle.BaseVehicleID
WHERE (vcdbchanges.tablename="BaseVehicle");
This will give a list of Make/Model/Years that have been added or deleted.
Revised: 2012-03-01
Copied!