Can a front end be shared by more than one user?
Posted on 2011-09-21
I have an access front end with no local tables (other than a couple look ups).
It uses a couple of linked SQL server tables and quite a bit SQL Server Pass through queries which have parameters passed to them at run time (i.e. order numbers, etc.)
I was planning on still giving every user their own copy of the front end, but then I read something (somewhere) that it may not be necessary, that something as simple as this could be shared?
I am thinking no, but wanted to ask the question here for more clarification.
The application detects the current windows username, and utilizes that to authenticate the user. In some passthroughs, the user name is passed as a parameter to pull only specific data for that user.
Having said that, my understanding is that this could not be used as a multi-user front end. Correct?
The reason for the question is that our IT group would rather have a single user link on our intranet that when clicked, runs the front end. I am thinking this will not work, and each user needs a copy of the front end either locally on their computer, or residing in their own personal network share folder.