Thanks Graham for your assistance.
I have Office Pro 2007 with everything installed.
Just to be safe, I downloaded the Office Primary Interop Assemblies and reinstalled them. By the way, to get it to install you have to rename "o2007PIA.msi" to "PIAredist.msi" (Thanks for that time waster Microsoft :~).
I still can't get it to do what I want. Maybe I'm confused about the difference between these two pieces of code:
Dim objAccess As Object
Set objAccess = CreateObject("Access.Application")
which works and .....
Dim oAccess As Access.Application
oAccess = New Access.ApplicationClass()
Which doesn't.
So I'll just carry on with the the first method.
Cheers.