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