Re: Users can import
From: Jeff Conrad (jeffc_at_ernstbrothers.com)
Date: 09/02/04
- Next message: Joan Wild: "Re: Removing Outlooks 10 minute timer for access by other select progr"
- Previous message: Allan _at_ cmgsales: "Removing Outlooks 10 minute timer for access by other select progr"
- In reply to: Joan Wild: "Re: Users can import"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Sep 2004 09:46:50 -0700
"Joan Wild" <jwild@nospamtyenet.com> wrote:
"I don't believe you can prevent them from creating a new database..."
The ADH book has a function called adhSetDbCreate that will deny specified users/groups to create
new databases. Before locking everything down really tight I deny all groups and the "semi-admin"
user to do this in my distributed MDW file. That way even if a savvy Access user manually joins the
distributed workgroup file they will not be able to create a new database and link/import to the BE
tables. I do, however, also deny all permissions to the tables as Joan mentioned.
-- Jeff Conrad Access Junkie Bend, Oregon > I don't believe you can prevent them from creating a new database, but you > can deny them permission to your tables and use queries set to Run with > owner permissions for all data interaction via forms/reports. > > Without permission to the tables, they won't be able to import/link. > > Read section 18 and 24 of the security FAQ > http://support.microsoft.com/?id=207793 > > -- > Joan Wild > Microsoft Access MVP > Mark wrote: > > I have a FE/BE database which is built on Access security. On top of > > this, I have also added my own security so that each usert (about 50) > > has their own userid. I have disabled the shift key on startup and > > was confident that it was secure. However, I have found that somone > > has been tampering with data which they should not have access to. > > After weeks of trying to figure out how it was done I have found that > > they did it by creating a new database whilst joined to my workgroup > > and then importing all the tables. Because that startup options are > > not set the same as mine, they can open up all of the tables they > > have read access on. > > > > Is there anyway that I can prevent users > > A) creating a new database whilst joined to my workgroup > > or > > B) Importing tables from my database?
- Next message: Joan Wild: "Re: Removing Outlooks 10 minute timer for access by other select progr"
- Previous message: Allan _at_ cmgsales: "Removing Outlooks 10 minute timer for access by other select progr"
- In reply to: Joan Wild: "Re: Users can import"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
