At last: success: I now have all 5 of my databases with the same users and the same owner and no passwords.
The way I have been able to get there was by UNLOADing each one and changing the database owner name in the output file and giving it a different password there. I added in a SET USER [ownername] [password] so that the new owner created the database then LOADed everything. Once all 5 had different owner names and different passwords I UNLOADed again and changed the database name but returned to my preferred owner name with no password. As before, I added in a SET USER [preferredownername] but with no password then LOADed everything. When all 5 were completed I checked then saved the original database files elsewhere and renamed my new databases to their original names. I don't pretend to understand what when wrong or why this process was what worked. All I do know it all the other things I tried that were suggested wouldn't work. At least I know that there is only a single error anywhere in my databases having re-created them so many times and now I can go back to finding the data type mismatch in my view! Thanks again to everyone that offered help. Regards, Alastair. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
