Solved it - my bad (lack of understanding). In the MOVE I was using the physical 'filename' not the logical 'name'.

I have tried without the database being created beforehand but the error is the same.

I have solved the problem (from the MSDN Forums) and provide the answer here for information:

cmd.CommandText = "sp_helpdb [" & txtOldCatalog.Text &...

This is the master data:

idfield1

2Risk Reporting

5Risk Scoring

6Compliance

7Risks

8In the next release ...

This the child data:

masterID field1

5 1

2 ...

That code returns the correct results that I was looking for!

Regards

James

Thanks Pradeep

That does work, but I need the WHERE as it is to show the Child records for a User (for example All Products and Products ordered).

Regards

James