Re: workgroup information file and remote users

I haven't used Access in a while but, assuming things haven't changed much,
answers are below. (You might want to confirm by posting in an Access
newsgroup.)


"DinosRose" <DinosRose@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C46B0C4D-F692-471B-87CB-0C1942E06CBE@xxxxxxxxxxxxxxxx
I'm reading through the general help file on user-level security and it
indicates that when a person logs on using their password, "Access then
goes
out and reads a workgroup information file". Does this mean that the user
needs access to where I save the workgroup information file when I'm using
the Wizard?

You can move the file after you finish using the wizard, but the user will
require read permission on the final location of the WIF file at runtime.
You can specify the location of the file via the "Jet OLEDB:System Database"
connection string property.


And if the user isn't connected to the network where this file
is saved, can they not access the database?

If the database is also on the network, then not having access to the WIF is
presumably the least of your worries. ;) If you are distributing the
database onto client machines, then it's typical to distribute a copy of the
WIF along with it.


At this point I'm trying to
determine the most appropriate security measure for our database
applications. Thanks!

Access user-level security is a rather weak authorization mechanism that is
fairly easy to bypass. If you're serious about security, you might want to
consider using a database server like SQL Server rather than a file-based
database like Access.


--
-DinosRose - sometimes I think I've gotten in over my head...


.

Relevant Pages

  • RE: User Level Security and Data Access Pages
    ... I'm having a problem getting User Level Authentication to work for a Data ... I have managed to get the page to work without any security in a Three Tier ... the User Level Authentication features of Access to secure the database. ... workgroup information file and in Access design mode, ...
    (microsoft.public.access.security)
  • RE: Help with security groups
    ... Join the workgroup information file using Workgroup Administrator ... that defines security for the database that is secured. ... Open the database you wish to unsecure using the logon that defines Admin ... Start Microsoft Access and open the secured database you wish to unsecure ...
    (microsoft.public.access.security)
  • Re: Multi user enviroment - part II
    ... Let's say for the sake of discussion that I have a multi-user database ... Give the new security file an ID, note the User, Organization, and ID ... MyAppFolder with the workgroup information file used when establishing ... "You can create a shortcut and enter this syntax as the target of the ...
    (comp.databases.ms-access)
  • Re: Access security model
    ... etc in a workgroup information file to a particular ... The workgroup information file is not linked to a database; ... databases use a single WIF and a single WIF can be used with multiple ... are able to open it - the Admin user is the same in everyone's system.mdw. ...
    (microsoft.public.access.security)
  • Re: How to add the security back to the normal database?
    ... I understand that you have exported Access 97 database to 2003 but you ... recorded in the workgroup information file. ... By default, on computers that are running Microsoft Windows 2000, the ... Microsoft Online Community Support ...
    (microsoft.public.access.security)