At my work, there are multiple MS Access forms being used, all linked
to the SYSTEM.MDW file. I, however, need to also create a form which
will be distributed to more than just my coworkers; some of these I
will not even have direct contact with.
What I need is a means to set myself and a few others (that I do work
with) as Admins, and anyone else who gets the form as a User. I have
set the Users group to have permission to open/run the forms, and I am
aware that the Users group means everyone. However, I have tried to
open the forms as a User and was denied permission. Is there a way to
set these permissions? Can permissions be set without the use of a
SYSTEM.MDW file? 4 1824 bl*****@carolin a.rr.com wrote: At my work, there are multiple MS Access forms being used, all linked to the SYSTEM.MDW file. I, however, need to also create a form which will be distributed to more than just my coworkers; some of these I will not even have direct contact with.
What I need is a means to set myself and a few others (that I do work with) as Admins, and anyone else who gets the form as a User. I have set the Users group to have permission to open/run the forms, and I am aware that the Users group means everyone. However, I have tried to open the forms as a User and was denied permission. Is there a way to set these permissions? Can permissions be set without the use of a SYSTEM.MDW file?
Go to Microsoft's site and search for the Access security whitepaper. That
will explain Access security. It's a rather involved process. (sorry, don't
have a link off hand).
Also, in case you are... DON'T use the existing system.mdw. Create a new
workgroup using the workgroup administrator. Otherwise anyone can access
your database.
Did you also set permissions for the underlying data behind the form?
--
regards,
Br@dley
I've set permissions for "Admins" and "Users" groups for all tables,
queries, and forms. The more I'm reading, though, the worse an idea
this seems to be. And yes, we are using system.mdw here at work, but
none of the apps relying on it are distributed. I've tried to create a
new workgroup file, but I never get the option (it's disabled in the
User Level Security Wizard).
I'll look for that access security whitepaper. If you happen to come
across the link, I'd appreciate the post, along with any other advice
you might have on this. Thanks!
On 22 Mar 2006 12:54:49 -0800, bl*****@carolin a.rr.com wrote: I've set permissions for "Admins" and "Users" groups for all tables, queries, and forms. The more I'm reading, though, the worse an idea this seems to be. And yes, we are using system.mdw here at work, but none of the apps relying on it are distributed. I've tried to create a new workgroup file, but I never get the option (it's disabled in the User Level Security Wizard).
I'll look for that access security whitepaper. If you happen to come across the link, I'd appreciate the post, along with any other advice you might have on this. Thanks! http://www.mvps.org/access/resources/techpapers.htm
Look for Access Security FAQ.
Wayne Gillespie
Gosford NSW Australia
Thanks Br@dley and Wayne, this looks like exactly the resource I
needed! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Hal Vaughan |
last post by:
I've been reading up on file permissions (including FilePermission,
Permission, and Permissions). From what I see, these are temporary and
forgotten when a program exits (if I'm wrong, tell me, please).
I'm installing a program on a computer and that includes configuration files
that change regularly. When I create the configuration files,...
|
by: Ross Presser |
last post by:
As our customers demand that we tighten our IT security in the company,
I've been asked to prepare a report quarterly showing, for each user in
Active directory, what his effective permissions are for every table in
every database that he has permission for on our SQL Server 2000 server. I
searched a bit for a tool to do this, but all I found...
|
by: Martin Ernst |
last post by:
Hello!
I wonder which font is normally used in IE (6) for windows if i use
"sans-serif" as font-family.
Does anybody know it? Thanks
Martin
|
by: Chris |
last post by:
I have seen the posts on various places on the internet about .NET
framework mismatch issues and I don't think that is my problem. ; )
When I execute the following C++.NET code:
String *ipAddress = S"";
IDictionary *server_config =
dynamic_cast<IDictionary*>(ConfigurationSettings::GetConfig("ServerAddress")
);
ipAddress =...
|
by: Jeff |
last post by:
I am trying to write some C# code that will allow me to determine if the
current user running my application has "write" permissions to a particular
folder. However, I can't seem to get it to work. In the code snippet I've
included below, it always returns "true" whether the folder/file exists or
not (let alone whether or not they have...
| |
by: Simon Harvey |
last post by:
Hi everyone,
If anyone can help me with the following - I would be VERY grateful.
I need to deploy an 2 ASP.net applications that I've been creating onto
one of our live servers. Both applications use the Microsoft Enterprise
Library dlls and have them located in their respective bin directories.
Everything works fine on my development...
|
by: jporter188 |
last post by:
Hello,
I am working on a project to manipulate XML files. All of the files,
the code, and the output are on network drives. When I run my program
I get an exception (see below). I tried giving the LocalIntranet_Zone
full permissions in the .NET Framework 2.0 Configuration msc. This had
no effect whatsoever. What do I need to do to fix this?...
|
by: Mike |
last post by:
Hi
I have problem as folow:
Caught Exception: System.Configuration.ConfigurationErrorsException:
An error occurred loading a configuration file: Request for the
permission of type 'System.Security.Permissions.FileIOPermission,
mscorlib, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089' failed. (machine.config) --->...
|
by: Fawad Ahsan |
last post by:
Hi
i am having problem with the microsoft enterprise library. i have uploaded
the site to the hosting server and it gives the following error
it works well in my server. can some one help me what kind of permission to
set?
thanks
Server Error in '/' Application.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
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...
| |
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. ...
|
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...
|
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...
|
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.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| | |