[dba-SQLServer]Log on showing same user as previous

Djabarov, Robert Robert.Djabarov at usaa.com
Wed Jul 2 13:38:02 CDT 2003


Copying FE from one PC to another does not copy registry values affected by SaveSetting/GetSetting.  The first time your program is executed the user will have to enter his/her ID.  The next time the value from the registry is retrieved via GetSetting.  If a different user is logged on to the same PC for the first time, - the story is repeated all over.  Of course it is possible to keep this information on the database server, but then the actual connection has to be made using hard-coded credentials that must never change.  This makes your app more rigid to distribution and more demanding for recovery purposes.

Robert Djabarov
Senior SQL Server DBA
USAA IT/DBMS
? (210) 913-3148 - phone
? (210) 753-3148 - pager


 -----Original Message-----
From: 	David Emerson [mailto:davide at dalyn.co.nz] 
Sent:	Tuesday, July 01, 2003 7:28 PM
To:	dba-sqlserver at databaseadvisors.com
Subject:	RE: [dba-SQLServer]Log on showing same user as previous

This takes me to the MSDN website.  It seems that the solution is to make 
changes to the registry settings.  Is this correct?

I am not sure if this is the correct solution as the user name must be 
stored in the actual FE itself (and not on the computer - otherwise the 
user that was used to link initially to the BE wouldn't appear on another 
computer that the FE has been copied to.)

Can anyone else help me out or explain further?

David

At 1/07/2003, you wrote:
>Check out SaveSetting/GetSetting in VB/VBA BOL.
>
>Robert Djabarov
>Senior SQL Server DBA
>USAA IT/DBMS
>? (210) 913-3148 - phone
>? (210) 753-3148 - pager
>
>
>  -----Original Message-----
>From:   David Emerson [mailto:davide at dalyn.co.nz]
>Sent:   Monday, June 30, 2003 11:47 PM
>To:     dba-SQLServer at databaseadvisors.com
>Subject:        [dba-SQLServer]Log on showing same user as previous
>
>I have an AXP ADP FE which is on several users computers.  It is connected
>to an SQL2000 BE.
>
>I used a full copy of Access to make the initial connection with the
>database.  However the users have various user names that they log in
>as.  Currently when they start up the runtime version it asks for the user
>and password for the SQL database.  The user defaults to the user that I
>logged on as to make the initial connection.
>
>The users want it changed so that when the box appears asking for the user
>and password, that the same user as they previously logged on as is in the
>user field and they only need to enter the password (it worked in Access 97
>so they want the same thing now).
>
>Each user does not have a full copy of access so that they can set up their
>connections.  I also don't want to have to make individual copies of the FE
>and connect then for each user.
>
>Is there some way for Access/SQL to remember the last user that logged on
>and use this for logging on?  I can extract the current user from the
>CurrentProject.Connection.ConnectionString property but where do I go from
>here?
>
>Regards
>
>David Emerson
>DALYN Software Ltd
>25b Cunliffe St, Johnsonville
>Wellington, New Zealand
>Ph/Fax (877) 456-1205
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list