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

David Emerson davide at dalyn.co.nz
Wed Jul 2 14:03:51 CDT 2003


Thanks for your help but I am still a bit unclear.

After making the initial connection to the server on one computer I copy 
the FE to other computers.  When the FE is opened on the other computers 
the logon (which is an SQL logon, not Access XP) shows the original user 
that was used to connect to the server.  This must either be stored in the 
FE somewhere, OR perhaps is stored in the SQL database itself?

I guess my first question is where is the default user name stored?

At 2/07/2003, you wrote:
>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



More information about the dba-SQLServer mailing list