Questions about creating SQL Server BE and MS Access FE connection with Linked table.

[DTO.]

Let your system admin to create a domain user group for your DB users, and add all those users to this group. This group is used for this DB only;


In case you also need the access to this database (e.g. for testing or debugging, etc.), let admin add you to this group also, or to create a special group for you (an other IT staff when they also need the access). When a separate group is created, then this group may be used for other DB's too;
In SQL Server, create login(s) for this/those domain groups;
Allow access for defined login(s) to your DB. Set reading/writing rights for login(s) according what is needed for members of given group.

Hello ArviLaanemets, Thanks for your reply.

I have contacted with my IT department for this request.. The guys says if every user will connect to the SQL Server, this will decrease the performance of the SQL Server.
Is it really so? I dont thinks it s a right argument. How all other applciations are used? Isnt SQL Server for this purpose already?

[Minty]

They will only connect when they are using the database, your IT guy is being a numpty.
If the server isn't to be used you may as well turn it off.

You can't turn on that light - You'll use some electricity!!
Don't breathe - You'll use up the Oxygen...

[ArviLaanemets]

Maybe your admin is somewhat confused - he/her not being DB admin (and me being generous )?

All what I described doesn't mean the user logs into SQL Server, or even can do this at all. This means that when a SQL connection is made by user's Front-End, the server checks the domain group of user who initiated the connection, and when he/her belongs to domain group having access to queried database, the connection to this DB is allowed. When the connection is allowed, the data transfer between user's FE, and SQL database (reading only, or reading and writing - depending on rights you set up for login) is allowed too.

[DTO.]

Thanks for all comments. I will make some tests and we will have a meeting tomorrow about it. I need to defend my argument to convince them