I have queries regarding on how would I handle things in a MULTI-USER 
environment setup: (assuming that there 10 or 15 users, 1M records, using ADO
and unbound forms)

1.)LOGIN-LOGOUT
	Any suggestion or tip on how would I make an algorithm or logic for a process that 
   would logged out the user on the previous machine that he had log on, if he will log in 
   again on another machine.  I want to prevent mulitple logins.

2.)How to get the newly inserted record made by the INSERT or ADDNEW statement?  If after the
   INSERT or ADDNEW statement is executed then I made a SELECT statement selecting the MAX 
   TrandID(-autonumber, for ex) or going to the last record in table would there be an instance
   that I might not get the record I recently INSERTED or ADDED?

3.)How can I lock a record that I will be updating using the UPDATE statement?  Are there no
   possibilities that there will be no collitions on using the UPDATE statement?

4.)This is the way I make use of TimeStamp Field upon Updating a record:
   a. I've created a SELECT statement that would get the record to be updated
         SELECT dtmTimeStamp FROM tblTranx WHERE TranID=6
   b. Check if the dtmTimeStamp is still the same with the current record I've edited.  If Yes
      then UPDATE statement would pursue but if not the user will be asked wether to reload the
      new data or overwrite it.
  Am I doing it the  right way?  Will there be no possibility that dtmTimeStamp will be a updated
  by another user in between the SELECT process and IF-THEN-ELSE process?

5.)From my Previous Post - Transaction History - tblTranx will be transferred to a main database.
   Actually I have asked this before on my other post and learned the importance of using
   Autonumbers as primary keys in the table.  Now my problem is if I transferred this data to
   the main database would I need to have an Autonumber field again to be the primary key?
   
   ===========                                    ===============
   Branch 001                                     CentralStation
   ===========                                    ===============
   tblTranx                                        tblTranx
   ---------                                       ---------
    TranID (AutoNumber)(PK)   -->  TEXT FILE -->   CSTranID (Auto)(PK) <---do I nid 2 create?
    SenderID (FK)                                  BranchID (FK)
    BeneID (FK)                                    TranID <-----is this needed to b importd?
    Other Fields.....                              Other Fields .....

       My another concern here is that the Sender and Bene are in a different table, if I 
    export it and be imported on the Central station how would it should be setup?  Have the
    Transaction info from tblTranx, tblSender, tbBene already combined and then put them on
    tblTranx of CentralStation or create also tblSender and tblBene in the CentralStation?

       Sorry for a very long post, I just wanna make sure I have everything ready before
    pushing through of creating forms and make progress.  Every Dbase application depends
    really much on how well the database were constructed.
   

Thanks,

Enzo c",)
YahooID: yackydidakdak