SQL server login (1 Viewer)

gar348

Registered User.
Local time
Today, 12:29
Joined
Jan 24, 2017
Messages
17
Hello

Is there anyway to add the SQL server login to the switchboard on my access database ?

Ie so this is the first screen the user sees so i can create individual SQL user ids, then when the SQL password is entered the main menu opens.
 

isladogs

MVP / VIP
Local time
Today, 12:29
Joined
Jan 14, 2017
Messages
18,186
Whilst you can do so...
Why do you want each user to login to SQL server individually?
Recommend you use the Windows login method instead

If they login to your database with a user name / password (e.g. using network login / password combination) , it shouldn't be necessary to do a further login to SQL Server
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 05:29
Joined
Aug 30, 2003
Messages
36,118
I assumed that the goal was to set different permissions for different users. I personally use Windows Authentication. You could probably use Windows Authentication and use AD groups for your permissions.
 

isladogs

MVP / VIP
Local time
Today, 12:29
Joined
Jan 14, 2017
Messages
18,186
Hi Paul

You just explained what I meant but more clearly than I did.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 05:29
Joined
Aug 30, 2003
Messages
36,118
Probably because it's not late at night here, and I'm not posting from a pub. :p
 

isladogs

MVP / VIP
Local time
Today, 12:29
Joined
Jan 14, 2017
Messages
18,186
Ah but you forget I've stopped drinking ....
Its late though ... signing off in a minute
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 05:29
Joined
Aug 30, 2003
Messages
36,118
Either you never told me, or I simply didn't believe it. It runs contrary to stereotype. ;)
 

Users who are viewing this thread

Top Bottom