I find that if I have the collection list in Details view, and try to restore the database, I get a series of error messages saying something like "Can't perfom operation when recordset is closed".

I have to kill the process to get out of this, after which the local database is obliterated. I can then restore as normal.

I seem to get an interminable number of sequential error messages - that's why I had to kill the process.