Many thanks for your prompt reply, Old Pedant.

What you suggest sounds like a good way of getting round the problem. I haven't tried it yet since, in the meantime, I found another solution - I used the free Microsoft SQL Server Migration Assistant for Access and succeeded in achieving the same end result, except that the resulting SQL database was accessible from both Microsoft SQL Server Management Studio Express and VB Express.

Nevertheless, out of curiosity, I will try your solution in the near future.

Again, many thanks.

I have now tried your suggestion but there are still problems:

I first created a new database in SSMSE but VB wouldn't connect with it, so I detached it from my Server. This allowed VB to connect and I used VB to create, yet again, all the tables and relationships. I then re-attached the database to my Server using SSMSE again. (I had to exit VB before this was possible.)

Then back to the Migration program: It still will not connect - I get the message "Cannot open database 'MyDB' requested by the login. The login failed."

What is wrong?