UPDATE dbo_MasterAccounts INNER JOIN dbo_SubAccounts ON
dbo_MasterAccounts.CustomerID = dbo_SubAccounts.CustomerID SET
dbo_MasterAccounts.Active = 0, dbo_SubAccounts.Active = 0,
[dbo_MasterAccounts]![Comments]+0x0D+0x0A+'12/29/99, bja, deactivated
WHERE (((dbo_MasterAccounts.Active)=1) AND ((dbo_SubAccounts.Active)=1) AND
It deactivates anyone who has been expired since 10/1/99 and adds a comment
in the master account so if you look at it later you know what was done.
Versions older than 2.5.294 also had a problem created phantom MBR's. You
can find them with this:
SELECT dbo_SubAccounts.Login, dbo_SubAccounts.AccountID,
FROM dbo_MasterAccounts INNER JOIN dbo_SubAccounts ON
dbo_MasterAccounts.CustomerID = dbo_SubAccounts.CustomerID
WHERE (((dbo_SubAccounts.Login) Is Null));
I was able to free up several hundred accounts this way.
btw- I did this in Access97 so the linked Emerald tables all have the prefix
> -----Original Message-----
> From: firstname.lastname@example.org
> [mailto:email@example.com]On Behalf Of david leigh
> Sent: Friday, January 21, 2000 7:38 AM
> To: firstname.lastname@example.org
> Cc: email@example.com; firstname.lastname@example.org
> Subject: [Emerald] Problems with Manual Invoices
> Hi All
> We are 25 users away from purchasing another 1000 MBR licences
> for Emerald.
> I'm nervous about doing so because I still haven't got an answer regarding
> the problem of manual invoices not being added to the Balance, but being
> subtracted from the balance when voided.
> Dale and Peter - I'm directly addressing you as the two most
> cluey people on
> this list. (But if anyone else knows the answer then I am
> desperate to hear
> 1) Can you confirm that this bug (which is a known bug from what
> is said in
> this lists archives) is repaired?
> 2) Can you tell me how to fix it on my installation (2.5.322 on SQL 7)
> David Leigh
> For more information about this list (including removal) go to:
For more information about this list (including removal) go to: