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