Database Users need to have Read/Write etc... permissions to the
folder where the Database resides in order to create the lock file.
I have read only users.
I have set up the Shortcut that links to the 'Workgroup Info File'
with permissions for said database.
Within this 'WIF' File I have "Read Only" user's who are only provided
access to the DB only so they can view the data.
Now if I give them full permissions to the folder where the database
resides, what am I to do to keep them from going to this folder &
opening up the database directly using thier local 'WIF' File?
Help would be greatly appreciated.
Thanks 8 3871
On 13 Mar 2007 11:53:38 -0700, pa****@gmail.co m wrote:
What can be preventing them from using the db any way but RO is the
proper application of user-level security. If you do it properly, they
can only do with the mdb (I'm assuming a back-end database) what you
have already setup for them to be allowed to do.
Applying this level of security is an advanced topic. Download, read,
and fully understand the Access Security FAQ from microsoft.com before
proceeding on a copy of your database (just in case you mess up).
This level of security can reportedly be defeated by password crackers
available on the internet. It is also a deprecated feature in Access
2007, so don't bet on it staying around forever. If you want real
security, SQL Server is your ticket.
-Tom.
>Database Users need to have Read/Write etc... permissions to the folder where the Database resides in order to create the lock file. I have read only users.
I have set up the Shortcut that links to the 'Workgroup Info File' with permissions for said database. Within this 'WIF' File I have "Read Only" user's who are only provided access to the DB only so they can view the data.
Now if I give them full permissions to the folder where the database resides, what am I to do to keep them from going to this folder & opening up the database directly using thier local 'WIF' File?
Help would be greatly appreciated. Thanks
The User's can access the DB via the Shortcut (linking the Workgroup
Info File) no problem.
Both my Read Only & Write Users...no problem. Permissions are working
fine.
My problem is that since all user's requre full access to the folder
containing the DB, they are able to copy the database, rewrite over
the database with thier new copy etc...
I cant really see my user's wanting to screw it all up in this
fashion, although you never know.
I read in other discussions some options
Applying Read Only permissions to the database itself. While keeping R/
W to its folder.
In another they had R/W to the containing folder & applied the
Traverse Folder special Permission as Deny to stop access to the
folder containing the DB.
Im just trying to figure out what the best option would be...
On Mar 13, 10:29 pm, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
On 13 Mar 2007 11:53:38 -0700, paq...@gmail.co m wrote:
So since ive removed the default admin permissions on the database im
not worried about users altering the data contained within the DB.
My only worry is "silly" users deleting or overwriting the database.
Currently my only recourse is Daily backups. pa****@gmail.co m wrote:
Database Users need to have Read/Write etc... permissions to the
folder where the Database resides in order to create the lock file.
I have read only users.
I have set up the Shortcut that links to the 'Workgroup Info File'
with permissions for said database.
Within this 'WIF' File I have "Read Only" user's who are only provided
access to the DB only so they can view the data.
Now if I give them full permissions to the folder where the database
resides, what am I to do to keep them from going to this folder &
opening up the database directly using thier local 'WIF' File?
Help would be greatly appreciated.
Thanks
If you applied security properly then it will not open with their local WIF
file.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
In you post you stated;
If you applied security properly then it will not open with their
local WIF
file.
Do you mean when then open the database via the shortcut ive created
or when they open the database directly?
When they open via the shortcut, the WIF ive created applies. When
they open the DB directly, thier WIF applies.
Now, according to the Microsoft support articles I read, there are
only 2 ways to apply a custom WIF File.
1. Use the "MS Access Workgroup Administrator" utility to have the
users join the WIF
(Which applies to all databases, & I only require it for this one
database)
Hence I went with option 2;
2. Create a shortcut to the DB with the cmd line argument " /wrkgrp"
This is what I did & it works fine, only if they use this shortcut.
If they go direct, they use thier own local WIF, which is useless
for this DB as I removed the default Admin permissions. Although they
do have access to the database's containing folder due to the required
permissions. pa****@gmail.co m wrote:
In you post you stated;
If you applied security properly then it will not open with their
local WIF
file.
Do you mean when then open the database via the shortcut ive created
or when they open the database directly?
When they open via the shortcut, the WIF ive created applies. When
they open the DB directly, thier WIF applies.
Now, according to the Microsoft support articles I read, there are
only 2 ways to apply a custom WIF File.
1. Use the "MS Access Workgroup Administrator" utility to have the
users join the WIF
(Which applies to all databases, & I only require it for this one
database)
Hence I went with option 2;
2. Create a shortcut to the DB with the cmd line argument " /wrkgrp"
This is what I did & it works fine, only if they use this shortcut.
If they go direct, they use thier own local WIF, which is useless
for this DB as I removed the default Admin permissions. Although they
do have access to the database's containing folder due to the required
permissions.
Okay, so now you are saying that if they try to open the file with their local
WIF they won't be able to because you removed the default Admin permissions. Is
that correct? If so then that is what I stated should happen. That makes this
question from your previous post a bit puzzling.
what am I to do to keep them from going to this folder &
opening up the database directly using their local 'WIF' File?
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
On 14 Mar 2007 10:37:46 -0700, pa****@gmail.co m wrote:
That is a good recourse.
Additionally you can have the db on an NTFS partition and turn off the
ability of users to delete the file. You can also turn on logging so
you would know who deleted the file if that happened. Then be ready
with your tar and feathers :-)
You know about the /readonly switch on the Access command line, right?
-Tom.
>So since ive removed the default admin permissions on the database im not worried about users altering the data contained within the DB.
My only worry is "silly" users deleting or overwriting the database.
Currently my only recourse is Daily backups.
So ive applied the proper NTFS file Permissions to the Database
itself. Leaving the Full Permissions to the folder.
I didnt use any Read/only switches in the cmd line though.
I applied the Read Only attribute within the Workgroup file. Thats
fine right?
SO as far as I can tell, all is well. I'll still do the daily backups
though & keep my tar & feathers handy in case some power user wants to
play tricks.
Hopefully I can move this all to SQL Server sooner than later.
THanks for the help guys. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Brent |
last post by:
I've got a site that uses ASP pages to make simple
connections to an Access 2000 database. The site has been
fine for the past few months. Last night I browsed to an
ASP page, and for some reason an .ldb file got created on
the server, and now none of the pages can connect to the
database. I've tried a compact/repair on the db, I've
even created a new database and imported all the files
into it, but that one did the same thing. Any ideas...
|
by: CJM |
last post by:
I'm setting up some web-based (ASP) reports that query an Access DB. I also
want certain people to be able to access and manipulate the database
directly.
However, if the database is open in Access, I cant access it via ASP:
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
|
by: Mike MacSween |
last post by:
I'm not talking Access Users & Groups, I may or may not implement that. Even
if I do file/folder rights still need to be managed.
I've searched the archives and read the many postings. The basic problem
seems to be this:
Access is a 'file server' based system. So if you want your users to use the
db they've got to have access to the file. And can do stuff to it you might
not want.
|
by: Thats Me |
last post by:
Background: Access 2000 running on Windows 2000, Did not design
inherited (three previous database maintainers in last 18 months),
Non-existent comments for existing code modules and objects, six
users on LAN, BE on shared server. Each user has own FE to allow
special report & query creation, each user has common forms for input
and edit of main table data, Main data tables are linked from BE,
special tables are stored in users FE. ...
|
by: John Baker |
last post by:
Hi:
Quick question: Using XP Home, should Access be installed in the Admin account, or in an
individual users account. If its installed in the Admin account, is it available to
everyone? I am a W98 user who is upgrading, and am uncertain about these things.
John Baker
| |
by: JonnyD |
last post by:
I am working on a project to build a reporting web app from an exsiting
database that is controled by a local application. The application that
has control over the database creates a lock file to the database and
at that point I can no longer access the database with my web app. Is
there anyway around this? All I need is read only access to the
database to get some report information to display on the web page.
The error I get on the...
|
by: James |
last post by:
I have a VB windows forms application that accesses a Microsoft Access
database that has been secured using user-level security. The
application is being deployed using No-Touch deployment. The objective
in utilizing this new deployment method is to reduce the maintenance
overhead as well as making it easier for my users to setup and run the
application initially. I have VS 2002, Windows XP, Access XP(2000
format).
He is my problem....
|
by: Enska |
last post by:
I have problems connecting my access database I get information .. I
cant use my database and I'm administrator on my computer so permission
shutnot bee problem, but I dont know Where is the problem. Can enybody
help me!!!!
Server Error in '/Koulu/tietokannat' Application.
--------------------------------------------------------------------------------
The Microsoft Jet database engine cannot open the file...
|
by: hugh welford |
last post by:
Hi
Have just installed IIS7 on Vista and am trying to access a .mdb file
through ASP. Getting server error.
I think the problem is in the file permission. Under XP Pro/IIS6 is used to
have to set the .mdb file security via windows explorer to give
IUSR_machinename full permissions on this file for anonymous web access.
Cant seem to do this with Vista explorer - says object cannot be found.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |