SQL server login

[gar348]

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.

 

[pbaldy]

I don't see why not. You could run code to link tables after they've entered their credentials. Perhaps this:

http://accessmvp.com/dJSteele/DSNLessLinks.html

 

[isladogs]

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]

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]

Hi Paul

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

 

[pbaldy]

Probably because it's not late at night here, and I'm not posting from a pub.

 

[isladogs]

Ah but you forget I've stopped drinking ....
Its late though ... signing off in a minute

 

[pbaldy]

Either you never told me, or I simply didn't believe it. It runs contrary to stereotype.