Re: authentication Mode

Consider using an Application Role rather than user level security.

Look in Books Online for "Establishing Application Security and Application
Roles".

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"JB" <JB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AA8A22DC-D007-4CBE-BFF8-758693B9FCC0@xxxxxxxxxxxxxxxx
I am developing a client/server application using sql server as the back
end.
This app must allow for two login scenarios other than the usual one
user/one workstation. First, the app must allow users to log in from any
machine on the network even when using a machine running under a different
users login. Second, the app must be available to someone that does not
have
a windows login, eg a field worker that needs to access the app
occasionially
using a machine running under a different users login. For these reasons,
I
have been using mixed mode authentication which does the job. Since all
the
documentation seems to recommend Windows authentication mode and mixed
mode
is for backward compability, am I missing something here? Can I handle
the
two scenarios, particularly the second using Windows Authentication?

JB


.

Relevant Pages

  • Re: Access 2003: Thinking about going multiuser with user security,...
    ... you're going to want some modules in the app that run on startup. ... This is especially important with regard to disabling the bypass key. ... Read through some tutorials about User Level Security and walk through the ULS Wizard a bunch of times. ...
    (comp.databases.ms-access)
  • Re: Access DB LockDown?
    ... Create User Level Security, then your VB app connects with the only account. ... Our concept VB6 app reads and writes to a MS Access database. ...
    (microsoft.public.vb.general.discussion)
  • Re: User level security in Access 2007
    ... Access 2007 supports user level security as long as the db file stays in the ... same file format as previous versions for Jet, not the new file format for ... I did try to convert a db with mdw files into .accdb file. ... The app did ...
    (microsoft.public.access.security)
  • Connection Open Error 0x80040e4d when UID/PWD added?
    ... Adding user level security to a working C++ db app. ... I add the user id and password to the connect string or to the connection ... Prev by Date: ...
    (microsoft.public.data.ado)
  • Re: Zone Alarm freezing my pc
    ... >> did with McAfee's parasite. ... >FTP, ... The app I am talking about is amgrsrvc.exe. ... -- "Good judgment comes from experience, and experience comes from bad judgment." ...
    (comp.security.firewalls)