Hello,
I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.
the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).
the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.
but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data. The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.
I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.
Please help me in this case ... the users are ruining and playing all my data.
5 3011 ADezii 8,834
Recognized Expert Expert
Hello,
I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.
the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).
the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.
but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data. The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.
I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.
Please help me in this case ... the users are ruining and playing all my data.
The fastest and easiest, although not the most effective, method of not allowing Users to see various Database Objects is: - Select Object(s) in the Database Window.
- Right Click on Object then Properties.
- Click on attributes ==> Hidden Check Box.
- The Object(s) will no longer be visible in the Database Window.
- You should disallow certain Menu/Shortcut Menu Options so that savy Users cannot reverse the process and Uncheck the Hidden Attribute.
- These steps are just a band aid and are not meant to replace a comprehensive Security System on your Database.
Thanks, it was very useful ... you were a big help (^_^) but don't get tired of my questions .. because I am a very naughty person (^_^).
Anyway, thanks a lot for your concern and assistance. If there is any better way to apply band security to my (B) Application, please provide I would be more delighted to learn it and will be tracking every reply.
ADezii 8,834
Recognized Expert Expert
Thanks, it was very useful ... you were a big help (^_^) but don't get tired of my questions .. because I am a very naughty person (^_^).
Anyway, thanks a lot for your concern and assistance. If there is any better way to apply band security to my (B) Application, please provide I would be more delighted to learn it and will be tracking every reply.
Applying User Level Security to your 'B' Application wouold be the opimal way to secure but definately not the easiest. You can attempt the: - Tools
- Security
- User-Level Security Wizard
- If you do this, make a backup copy of your database and also your System.mdw (Workgroup) file.
- BTW: I left you a message concerning your other problem
Hello ADezii,
Thanks for your kindly reply ... the answer that you provided me was very useful because it is full of critical things ... but it requires me to read every single word to know and choose what suits my requirements ... but if you see that is it right for me to learnt it and use it for my (B) Application .. then I am ready for the extensive learning (^_^).
Again ... Thansk a lot
ADezii 8,834
Recognized Expert Expert
Hello ADezii,
Thanks for your kindly reply ... the answer that you provided me was very useful because it is full of critical things ... but it requires me to read every single word to know and choose what suits my requirements ... but if you see that is it right for me to learnt it and use it for my (B) Application .. then I am ready for the extensive learning (^_^).
Again ... Thansk a lot
Anytime, meLady.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Dean J. Garrett |
last post by:
We've had a small Access database driving a website using ASP code for a
couple of years now. About 2 months ago, the code would intermittantly get
database access errors like the one below. It doesn't always happen, in fact
it can go for days without happening. When this started, the Access database
was Access 97, but since then we've...
|
by: Joe Harrison |
last post by:
Hello.
I am having problems connecting ASP.NET to an Access Database. The
Access Database is on one computer (ALPHA) and the web server is on
another computer (BETA). I realize that the reason is because the
ASPNET user account on BETA does not have permission to the Access
database on ALPHA.
After doing some searching, it seems that...
|
by: gdonald |
last post by:
Hi
Wonder if anyone can help me. I am running an access 2000 application
with the backend on a server running windows 2003 and a seperate front
end on each users machine.
When i designed it, it was designed with a link table so that the user
is always connected to the back end but since the server was upgraded
the application has...
|
by: CJJ |
last post by:
hi Folks,
I am opening my access database file (Access 2003) from a C#
application. The connection string specifies mode=Share Exclusive
The intent is that the application have exclusive access to the
database file. No other instance of MS Access or this particular C#
application (or any other app) should be able to open the access...
|
by: Bob Alston |
last post by:
I am looking for others who have built systems to scan documents, index
them and then make them accessible from an Access database. My
environment is a nonprofit with about 20-25 case workers who use
laptops. They have Access databases on their laptops and the data is
replicated.
The idea is that each case worker would scan their own...
| |
by: cwoll |
last post by:
I have a Database that I am trying to run on a new vista computer. Up
to now I was running it on a win 98 computer and using access 2003! I
installed access 2003 and I can make it run and view the data but I
can not save any new records.
Has any one seen this problem yet?
Thanks Clarence Wollman
|
by: Killer42 |
last post by:
Hi all.
I have an application that I wrote ages ago - last compiled in 1998, I believe. It is still in occasional use. It uses an Access database - probably Access version 2, I think.
I implemented a fairly simple security model on the database way back then. As far as I can recall, I removed all access from the default Admins group and so...
|
by: buz |
last post by:
I have a database that was built using Office 97 version and would
like to update a more current platform. This program runs on a server
and the enduser runs the program from thier desktop. Windows NT
setup. When updating the end users with Office 2003 and they
connected to the server database...many errors occurred. I reverted
them back to...
|
by: veer |
last post by:
Hi
i create database of ms-access using vb.net code but it create the msaccess database of format 95 is there any way how to create ms-access database of format 2003 because my system has ms-office 2003
i used the following code
If System.IO.File.Exists(dbPath) = False Then
CrDataBase = CrEngine.CreateDatabase(dbPath,...
|
by: dewald4305 |
last post by:
I just converted an Access database from Access 2000 to Access 2003. My Combo boxes are now not working. They do not display anything in the drop-downs. What do I need to change to make this work?
Any help would be appreciated!
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
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...
|
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...
| |