OK that worked! Heres how:
Select the layer with the link to Access then right click on it and choose Data->Export Data to save a new shape file with all the data saved into the shape file (not as a link).

This newly created layer with can now be exported by KMLer with all the data.

Thanks
G