THAT was one heroic piece of work!
Good news.
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
------ Original Message ------
Sent: 2/2/2017 8:11:19 AM
Subject: Re: [RBASE-L] - View: Union / Group By - Success!
From: "Alastair Burr" <[email protected]>
To: "[email protected]" <[email protected]>
Cc:
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.
--
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.
