After running the Site Activity Report the entries in the LASTACCESSED column all show the date 1/1/1900

The Site Activity report pulls it's data directly from the SharePoint WSS_Logging database. If the Last accessed date shows as 1\1\1900 this means that there is no newer record of activity within the date range available in the logging database.
The incorrect date range may have been used when running the report