The list cannot be displayed in Datasheet view

Basically, the access ActiveX or stslist.dll is in incorrect version or incorrectly registered in the registry
(main culprit is usually a mix of office versions, so office repair can do the trick)
BUT
Simple solution if the target is 2007 : You can download the component in a separate install

2007 Office System Driver: Data Connectivity Components