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

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