question now is "HOW DO YOU REMOVE A MISSING REFERENCE IN VBA".

I've read some more on Google and I think I'm onto a non-starter here - the
question has been asked before and the answer that I've found so far is "You
can't remove a missing reference from VBA, the functionality doesn't exist".

The answer is to use late binding which isn't half-way as nice but at least
it'll work.

Now what's the CreateObject syntax for ADOX catalog please? :-)

Thanks, Rob.