To mearhm re: tracking old SLX Users

[Kari]

Hi-
In a past message about missing notes/historyin remotes because of
removing former users you mentioned creating another users table to
keep track of them. Would you mind elaborating on how you did this?
Do you have all fields having to do with the User ID pointing to this
rather than the System table?

Thank you in advance for any advice.
Kari Storm
NewsBank, inc.

Sent via Deja.com http://www.deja.com/
Before you buy.

[mea...@my-deja.com]

Here is what I did:
I created a table called User_Archive with all of the userinfo fields
plus a boolean that I called "gone".
I created a trigger on the userinfo table that copies all data from any
line inserted in the userinfo table and inserts it into the
User_Archive table.
I created another trigger that copies any updates from the UserInfo
table to the User_Archive table.
Then I created a delete trigger on the UserInfo table that marks the
boolean on the User_Archive table to True when someone is deleted.
Then I went through all of the forms and reports and changed the joins
to the new table.

You could accomplish the same thing by renaming the Userinfo table and
adding a boolean to it.
Then create 2 views:
The first you call UserInfo and only display records that have a
boolean value of false.
The second you call whatever you want and display all records.
Then make a delete trigger that adds the deleted record back to the
table with the boolean marked true.
This second method will eliminate the overhead of the second table but
will offer slower performance.

Either way, you have to point all of the forms in the database at a new
table or view.

My other suggestion is to yell and scream at SalesLogix (as I have) and
ask them if they have a 0% turnover rate with employees.
It is about time they fixed this oversight.

I have also found that you can trick the workgroup administrator into
having a negative number of licenses remaining and it does not stop
working normally.

Now, I expect everyone who reads this to follow the license agreement
and run their database legally.
I am in the software business and I would never dream of telling anyone
to violate a license agreement.
The fines are up to $100,000 PER OFFENSE (which can be interpreted as
per license), and it is one of the few laws that can go after personal
assets of company executives.
However, if you are extremely frustrated, you may want to contact
SalesLogix and request they allow you to do this with former employees
until they have a solution that will allow you to make that license
available without data loss.

If you need Pat Sullivan's personal email address, let me know...

In article <8ne9ha$s1k$1...@nnrp1.deja.com>,

[Kari]

Thanks for the informations. I would like Pat Sullivan's email. You
can send it to me at kst...@newsbank.com

I would love to complain, it's one of the things I do best. :)

Kari

In article <8neki6$9vs$1...@nnrp1.deja.com>,