Dan Waters
dwaters at usinternet.com
Tue Nov 25 20:24:14 CST 2008
Hi David, That code sounds handy - send a copy! Thanks! Dan -----Original Message----- I use SQL authentication with my ADPs but I check for username when starting the adp. If fOSusername() <> the connection string logged in username, then I prompt for a username using frmLogin. I then change the connection string. So the only time they ever have to log in is when I put out an update to the FE. I can give you my sample code if you want. David On Tue, Nov 25, 2008 at 2:56 PM, Dan Waters <dwaters at usinternet.com> wrote: > Hi Charlotte, > > They do understand this, and I'll be sure to bring it up again. But, they > are the ones who asked me if I could get rid of the login. They are > thinking that this could be a feature that would make more people accepting > of using the application. > > The customer may not do what I would do, but they do pay the bills! ;-) > > Dan > > -----Original Message----- > If your client has an IT department, they are currently screaming bloody > murder over that idea. It means you're leaving your SQL Server database > at the mercy of any user who logs onto windows and then goes for a long > coffee break leaving someone else to poke around in their machine. > > Charlotte Foust > > -----Original Message----- > I'm working on upsizing one of my customers to SQL. They have asked if > we could eliminate the Access workgroup username and password login that > I currently use (mostly just so the database knows who is logging in). > > With SQL using Windows Authentication, my Access app could simply pick > up on the current username and go from there, without going through an > additional username and password entry. > > Has anyone done this? Any pros, cons, or gotchas? > > Thanks! > Dan > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com