Does anyone know if it is possible to prevent a user from accessing
the tables in an MDE file? I can go to my start-up menu and limit
access to various functions, etc. I could even disable the 'close'
button on the forms. However, all a user has to do is hold the
SHIFT key down while launching the MDE application to bypass the
start-up menu.
I would like to limit any kind of data access (add/delete/modify)
through the forms that I have created. The purpose of the MDE is to
block access to my VB code.
The MDE file has linked tables to a centralized mdb file. So, I still
need the user to have the flexibility to access the "Linked Table
Manager" and to "compact" database (MDE grows every time you use it
even though no data is stored in the MDE).
Is it possible to 'hide' that tables. Unfortunately, if someone had
'View - Hidden Objects' selected in their Options, they would see the
hidden tables.
Thank you in advance for any ideas. 5 10345
You'll have to use the Access user-based security. Read the Access
Security FAQ available on MS Knowledge Base site: http://support.microsoft.com/default...09&Product=acc
And the Security white paper (Acc 95 - but, can be used for all versions
[except 2.0]): http://support.microsoft.com/default...55&Product=acc
HTH,
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Jay McGrath wrote: Does anyone know if it is possible to prevent a user from accessing the tables in an MDE file? I can go to my start-up menu and limit access to various functions, etc. I could even disable the 'close' button on the forms. However, all a user has to do is hold the SHIFT key down while launching the MDE application to bypass the start-up menu.
I would like to limit any kind of data access (add/delete/modify) through the forms that I have created. The purpose of the MDE is to block access to my VB code.
The MDE file has linked tables to a centralized mdb file. So, I still need the user to have the flexibility to access the "Linked Table Manager" and to "compact" database (MDE grows every time you use it even though no data is stored in the MDE).
Is it possible to 'hide' that tables. Unfortunately, if someone had 'View - Hidden Objects' selected in their Options, they would see the hidden tables.
Thank you in advance for any ideas.
Try looking in Tools, Startup.
Uncheck all those boxes. Make a backup first because you won't be
able to get in either. :)
Pachyderm ja*********@hot mail.com (Jay McGrath) wrote in message news:<e5******* *************** ****@posting.go ogle.com>... Does anyone know if it is possible to prevent a user from accessing the tables in an MDE file? I can go to my start-up menu and limit access to various functions, etc. I could even disable the 'close' button on the forms. However, all a user has to do is hold the SHIFT key down while launching the MDE application to bypass the start-up menu.
I would like to limit any kind of data access (add/delete/modify) through the forms that I have created. The purpose of the MDE is to block access to my VB code.
The MDE file has linked tables to a centralized mdb file. So, I still need the user to have the flexibility to access the "Linked Table Manager" and to "compact" database (MDE grows every time you use it even though no data is stored in the MDE).
Is it possible to 'hide' that tables. Unfortunately, if someone had 'View - Hidden Objects' selected in their Options, they would see the hidden tables.
Thank you in advance for any ideas.
"Pachydermi tis" <de******@hotma il.com> wrote in message
news:4f******** *************** ***@posting.goo gle.com... Try looking in Tools, Startup. Uncheck all those boxes. Make a backup first because you won't be able to get in either. :)
Sure he could! Just open the db using dbengine.openda tabase() and reset the
relevant properties.
TC
"TC" <a@b.c.d> wrote in message news:1074662335 .830060@teuthos ... "Pachydermi tis" <de******@hotma il.com> wrote in message news:4f******** *************** ***@posting.goo gle.com...
Try looking in Tools, Startup. Uncheck all those boxes. Make a backup first because you won't be able to get in either. :) Sure he could! Just open the db using dbengine.openda tabase() and reset
the relevant properties.
In addition to that, if the users need to be able to use the Linked Table
Manager to change or refresh the links, then they will easily see the path
to the back end file and could link or import those tables into a separate
MDB.
It's important to make the distinction that you are obfuscating, not
securing. While this can be very effective against many (perhaps most) of
your users, it is not much of a barrier against users who have any
familiarity with Access.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: James |
last post by:
Hi,
I am running a virtual hosting server. The configuration of server is
as follows:
Windows 2000
IIS 5.0
All the virtual hosting sites are running as seperate user ie for the
site www.xxx.com is running under xxxIIS and www.yyy.com is running as
|
by: Paul |
last post by:
Hi all, at present I I've built a website which can be updated by admin and
users.
My problem, I've combined "log in" and "access levels" to restrict access to
certain pages, using the built in "log in" and "user authentication,
restrict access to page" features. But I find the after login I constantly
get redirected from the restricted pages.
|
by: Neil Coleclough |
last post by:
I am constructing a database to process product returns for my Company.
I have a number of toggle buttons to identify the stage to which each
return has been processed. For example, clicking the first button
confirms that the goods are now in our building awaiting initial
processing. This button then fires off an email to our warehouse staff
alerting them to the fact. I want to restrict these buttons to single
use, so that once the email...
|
by: Jaydeep |
last post by:
Hi,
I want to restrict any user if he types url directly in the browser
without logging to my site. Like for example user should not see any listing
page of my web site by typing url http://localhost/customerList.aspx or
something like that, instead he should first login and then access this
page. How to achieve this functionality.
In classical ASP we used to include a common file which checks if cookie is
set or not or using...
|
by: toddles666 |
last post by:
Hi-
Is there any way of restricting access to a database by application &
account? For example, I only want the application APP1 to access the
database using the USER1 account. I've tried to use the DB2 Governor to
do this, but it seems it always allows the the first query to be
processed before forcing the connection. Here is my db2gov config
file:
--- start config
| |
by: teddysnips |
last post by:
One of my clients has asked me to make a change to one of their Access
applications.
The application is a Front End/Back End standard app. I didn't
develop it, but looking at it tells me that it was done entirely using
the Wizards. There is no log-in procedure.
They want to amend it so that only one person can be logged in at any
one time. So, if Joe Bloggs tries to open the application, and Fred
Jones has already connected, Joe...
|
by: %NAME% |
last post by:
Suppose I am an admin of a database instance. Now
I need to specify that user A has the right to create tables
in his own schema, but not anywhere else.
In order to let user A create tables, i grant createtab to that user.
However, that would enable the user to create tables in other schemas
as well (except those sys schema).
Any way to restrict the users from creating objects in other schema
than their own?
|
by: phpnoob |
last post by:
I have a php script that processes a form and then posts the user
input to a data file on the server in a comma delimited format. For
simplicity call the file "data.csv." The script is working well and
the data is posted correctly to the data file.
The big problem is that anyone can point their web browser to
www.mywebsite.com/data/data.csv and see exactly what is contained in
the data file. Obviously, I want the data in that file to...
|
by: =?Utf-8?B?R1ROMTcwNzc3?= |
last post by:
Hi there, I've got the standard Dreamweaver restrict access to page behaviour
below –
<%
' *** Restrict Access To Page: Grant or deny access to this page
MM_authorizedUsers="1,2,3"
MM_authFailedURL="index.asp"
MM_grantAccess=false
If Session("MM_Username") <"" Then
If (false Or CStr(Session("MM_UserAuthorization"))="") Or _
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: 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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: 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: 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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |