I'm sure this has been asked a million times but I can't seem to find the answer I need.
I am working in Access 2007. I have a very simple project composed of one main table, several look up tables, one switchboard form, two other forms (one data entry form and one query/search form), and one report.
I need to set this up with two levels of access:
1) people entering data can only see the forms and report, no access to any tables. It would be great if they couldn't even see the tables.
2) one person with access to everything (not me, since i'm shipping this whole thing off to the folks I'm creating it for). This person may need to delete records from the main table or add values to the look up tables, etc.
One idea is to password protect the tables. Another idea is to split (?) the project into front end/back end. I've seen people mention this, and have seen NeoPa's write up ( here) but in reality I have no idea how to do either. I'm not a coder, but can hack things together fairly well.
I'm told the project will be on one computer. There is no access to SQL Server or anything fancy/complicated. We're not concerned with people hacking the data, just want to avoid mistakes or people poking at tables they shouldn't.
Ideas? Thoughts? Advice?
58  9809  NeoPa 32,568
Recognized Expert Moderator MVP
I suggest you have the database start in a mode where the database window is not visible, but your main controlling form (could be switchboard) starts automatically.
It's not clear yet how you would envisage determining which user is the current operator, but I would have code that executes when the main form is closed that checks the user, if they are allowed then proceed to show the database, whereas if they are not it would close the database itself.
Does this sound like it would suit? Is this secure enough for you?
Yes I think so. So basically when you launch the database (double click on the file name) is the first window that shows up something that asks for a password? Or something similar?
How do I hide the database window? Or password protect it? I'm a little unclear on this part.
How about this? Split the database into front end and back end. Change the front end to an accde file. Rename the accde to accdr so it is a run time file.
The accdr file resides in a main location where data entry folk can launch it. The accdb_be (back end) file resides in a hidden location on the same computer so the data entry folks don't know where it is and won't open it but the database admin person can launch it to make changes to the tables.
Anyone see anything wrong with this?
NeoPa 32,568
Recognized Expert Moderator MVP AccessIdiot: Yes I think so. So basically when you launch the database (double click on the file name) is the first window that shows up something that asks for a password? Or something similar?
That's what I was asking you. You can get any form to start up automatically by playing in Tools / Startup. AccessIdiot: How do I hide the database window? Or password protect it? I'm a little unclear on this part.
You can also control from there whether or not the database window shows.
As far as determining whom to allow in goes, that rather depends on what you want. You can set up a form to make the user log into a session. Alternatively you can get the Windows account name that was used to log on to Windows (or the domain). As security isn't an issue, it makes perfect sense to get the user name from the environment variable. It's quite easily cracked, but if that isn't likely to be an issue then the method is fine.
NeoPa 32,568
Recognized Expert Moderator MVP AccessIdiot: Anyone see anything wrong with this?
Only that it's not exactly what you asked for. It would be tighter security, but splitting FE & BE in this case would not be relevant. I wouldn't advise against it as such, but I don't see it pertains to this unless you are, after all, unhappy with my earlier suggestion. You certainly wouldn't want to do both (although simply splitting the FE & BE in itself isn't incompatible). Actually this is hard to comment on as a bunch of ideas have been thrown across each other and dealing with the full ramifications of each would be a whole pattern that needed unpicking.
Only you know what you need. From your earlier comment that my suggested solution was adequate, there is little point in complicating the matter further. If that no longer holds, or you've changed your mind on it, then we'd need to know that before proceeding to avoid confusion and talking at cross purposes.
Hi,
Just want to contribute a few ideas here.
I am using a custome API function to completely hide/remove Access window while showing the forms only.
I think that will prevent people from viewing any Access Objects,like Tables Reports, etc.. apart from the forms.
If you think this will solve your problem post to inform for the function.
Whew. I'm certainly not looking for anything complicated and I don't think it needs to be mega-secure. I'd just like to create something where only one person has access to the tables and everyone else has access to the forms only. I don't really like the idea of splitting the database - one too many parts to keep track of. I think I'd prefer to have a start up screen that asks if you have a password (and it can be one I assign, or one that's stored in a table that he can change?). If you do, enter it and have access to everything. If you don't have a password, then move on to the regular old switchboard which leads to only forms and the one report.
Thanks for the advice and help!
NeoPa 32,568
Recognized Expert Moderator MVP
Are you sure you wouldn't like simply to check his Windows Logon? It's so easy and doesn't require any forms or special handling that needs to be rerun if the project ever resets itself.
If its easy then yes I'd love to do it! No need to remember separate passwords. I need to try and get this implemented fairly quickly.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: dan glenn |
last post by:
(PHP 4.3.4) THIS IS DRIVING ME NUTS!
I have a website where I offer members their own bit of webspace to use and
am coding a very simple 'filemanager' that allows a user to upload, delete,
and edit text files (members, of course, will not have normal sign-on FTP
access to the site - I just limit them to their own folder space). I'm
hitting a real problem with file and directory permissions, in that it seems
I'm experiencing...
|
by: Ray Lavelle |
last post by:
I'm new to VB .NET. In the past when creating an application, if I
had an input form I would just call the set and get methods on the
object that mapped to my database table in order to store and retreive
the data for that form. I would manually set each field if the user
was editing a record and I would copy each field from the form into my
object when they click save.
I want to develop some new forms but this time I want to try to make...
|
by: jwa6 |
last post by:
I have a user/pc specific problem in access.
This doesn't occur on any other ( windows xp pc) that I have used the
..mbd on.
This involves a query that's using a range of dates as a parm. This
query uses a form for the date range to be entered.
The date form uses a macro to verify that the dates are entered.
|
by: Ed B |
last post by:
I've been trying to connect to SQL Server 2000 through a web form created in
c#. As I created my connection object the data source test succeeded. I've
even tried the datapage wizard and I get the following message:
Login failed for user '\'.
|
by: zoltix |
last post by:
Hi,
I would like to access to execute specific commands but the privileges
are not enough from an aspx Page. Because this service run as
IU_IISSERVER, therefore aspx hasn’t access to these resources and it is
normal.. But sometimes, I need these privileges for special commands.
How to execute some “lines code” for other user than currently logged
user?
Thank you for your help
| | |
by: dbuchanan |
last post by:
I have a Windows Forms application that accesses SQL Server 2k from a
small local network. The application has been used for weeks on other
systmes but a new install on a new machine retruns errors.
The machine is a new laptop Windows XP Pro SP2
The machine is up to date with respect to the dot net framework.
Details:
Dot Net Framework ver. 1.0.3705 is installed
Dot Net Framework ver. 1.1.4322 is installed
|
by: ashish |
last post by:
I have written a simple forms authentication login page, where a user is
redirected to default page after he is logged in ...
the login page submit button looks like
FormsAuthentication.RedirectFromLoginPage(user.Email, false);
Is it possible to get user email on other pages ....
|
by: =?Utf-8?B?QmVuamFtaW4gSmFuZWNrZQ==?= |
last post by:
Hi,
we're struggling with a strange session problem in an ASP.NET 2.0
application. The application is used by our customers to access
customer-related information such as invoices over the internet. Customer
have to log-in and are then identified by their customer number and some
other information stored in the session. We use the asp.net session cookie
system to keep track of the sessions. This works quite well. Unfortunately
though,...
|
by: Chris Zopers |
last post by:
Hello,
I have two UserControls on a aspx page. I need to read a property of the
first UserControl from within the second UserControl. The UserControls
only know about themselves, so I can't declare a variable of the other
usercontrol's type. So I can't do something like this in the second
UserControl:
FirstUserControl first =
(FirstUserControl)this.Parent.FindControl("FirstUserControl")
|
by: damola |
last post by:
Good day everyone
Please how can i prevent access to certain forms in ms access database 2007.
i want it to be in such a way that when i enter user login,it automatically detects the forms the user has access to and the ones the user doesn't have access to it will say access denied
thanks for your help
|
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:
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
