Dan Waters
dwaters at usinternet.com
Tue Nov 25 16:56:35 CST 2008
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