Dear All,
Hello,
In my MS-Access have many Tables,Reports,Forms.Want give read,write permitions to admins’ and ‘users’ have only read permitions for reports ,Pls help me how to create permitions
for admins’ and ‘users’ by login.
Thanks
Manish
How can I create a log-in form with different level of authorization? It means different user is allowed to access specified content (table, query, report, form).
View 2 Replies View RelatedI have a voting application that need to limit users to only be able to login once to vote.Firstly how do you record in a table when a user login and at the login form how do you check to see if the user have logged in previously.
I have a login form with a username and password fields that work perfectly.
I need to separate Users and admin on login so that the admin can go to admin form and users to specific form using vba access. Here is my login code
Private Sub cmdLogin_Click()
'Check to see if data is entered into the password box
If IsNull(Me.cboUserName) Or Me.cboUserName = "" Then
MsgBox "You must enter a Password.", vbOKOnly, "Required Data"
Me.cboUserName.SetFocus
[Code] .....
I have been searching for info with users & permission levels. I have ready a lot about ULS (User Level Security) which doesnt seem to be my answer as I do not have admin rights and I believe it is not suitable with Access 2010.
Basically I have an 2010 Access database which is used by my department as a project management tool. It has various tables, forms, queries & reports, I have created a table with user names & passwords and a login form. So when the databases opens the login form is launched & the users selects their user name & enters their password, then the main menu is shown.
Everything works really well, but as the moment there is no difference between all the users. All I want to do is to be able to make one of the Logins read only, ie if the Reviewer is logged in they can see & read every form and run every report but they can not make any edits.
Hi guys,
I need help in setting up a login page which would redirect users to their specific directory, file, or URL.
I'm able to create the login page without any problem but i'm unsure what exactly i need to do afterwards to get this to work.
can someone, anyone please help
your help would be much appreciated.
please mail me with any information you might have the1@studio9.shacknet.nu
thanks in advance.
I need to create a report that has three labels as a heading on one level and then it will display the rest of the headings on another level.
View 2 Replies View RelatedI have a ms access application in Front End and linked tables to sql server 2008 r2 in back end.. every time I open my application the linked tables ask to me for the user and password of the sql server user of the odbc conection. I want to connect to my sql database without login every time the user open the application, I know that can be possible if I start session from vba code...
View 2 Replies View RelatedI have access 2010, I currently have a database in place and operational. What I am wondering is there a way to have a form come up whenever someone opens access and asks for a password and login name. Also I would like to have a 2 tier system. One for Admins and the other for users with limited access.
Is this even possible to accomplish?
Hi,
I have a table of users somthing like this:
User_ID
Name
Hobby
Favorite_Food
Blah
Blah
Blah
Users can be friends with one another and I need some way of logging this.
My 2 options (that i can see) are:
1) Putting a friends entry in the main user table then comma delimiting the User_ID's in the friend entry like so:
User_ID: 001
Name: John
Hobby: Frizbee
Favorite_Food: Cake
Friends: 002,004,010
2) Making a seperate table with multiple entries for each user like so:
User: 001
Friend 002
---
User: 001
Friend: 004
---
User: 001
Friend: 010
---
User: 002
Friend: 001
---
User: 004
Friend: 001
---
User: 010
Friend: 001
---
The database has to be handled by a web service and/or a web appliction making the comma delimited option occupy more server time breaking down the string into usable user_ID's.
But (and this is probably my actual problem) if i was to impliment my second idea, I'm not sure what I should make the tables primary key or the best way to relate it to the main user table.
My initial thought is to just have a, technicaly useless, ID be the primary key and impliment a one(User) to many(friends entries) relationship... but im a bit of an access n00b so thought i better come ask for some advice.
Thanks.
Hi. I am trying to complete my access database by creating some security for it. I want to know how to setup the database file so when I execute, let say in my document folder so that when it opens it only shows my switchboard and not the editable(table,queries...) panel on the left hand side. I know i can hide it via the startup option but I want to completly blocking it so it doesn't allow any user to edit the design of the database.
If anyone can help I realy appreciate it...thank you
how to make low security level, when i'm installing database only with access runtime? i my computer i have low level, but when I installing DB on other computer i need access to set level of database from medium to low.
View 1 Replies View Relatedhi
im doing a booking database for my a level coursework, i have got everything working in the tables and queries, just need to know how i can search a query in a form using a subform, and enter a new appointment into the query and have it update the current table?
ive done the subform bit before but have forgotten how lol.. help would be appreciated thanks:)
Hi,
I've created some subforms and wanted to create a subform of one of the subforms. When I try that Access creates just another subform of the original parent form.
Is there a way of doing that please? It doesn't seem to be covered in the Help section.
Thanks in advance.
Bee
I was wondering if somebody new how to make a query that started off asking (as parameter) for a number (this number represents the low number of performance) and the query would only show the performance below this amount.
Thanks
Hi - I am an Access newbie. I would like to use Access to develop a checklist that uses a two dimensional parent table (with row and column titles) that, when a check box is selected in a given row/column location, a specific sub-table is displayed. Likewise, when certain conditions are satisfied on a given sub-table by clicking on a check box(es), I would like to indicate the status with color and/or text in the associated row/column location on the parent table. Any ideas on how to accomplish this would be greatly appreciated.
Thanks - Mike F.
I have offered to help a local school ICT Dept with their A level projects. the first database they send me and I can't get further than the sub menus.
I would appreciate any assistance as I don't know wether it is something I am doing wrong or something within the structure. I've opened it using the Shift key to look at the code and can't see anything wrong. Any help will be very much appreciated. Regards. Bernard
Why does Excel have an emphasis on macro security level (high, medium, low) but Access doesn't? Both use VBA.
Also when Excel loads it always requests a virus scan but when Access loads it just loads? How come?
On another note why doesn't Access have a Macro Recorder?
Thanks.
Hi, I need to add a security feature to my database. Basically I want different users to access the database with different permissions. I want a "basic user" to be only able to access the the forms with their respective default settings. I want an "admin" to obviously be able to access all the content and edit the design. I know I can do this with User-Level Security somehow, but i've tried it and it isn't working like I want it to. DOes anyone know or have any experience with this security feature.
View 10 Replies View RelatedHow can i make the following access level in a MS ACCESS 2003 database?
level1----------->[Table A : Data Entry],[Table B : Only view]
level2----------->[Table B : Data Entry],[Table A : Only view]
How do you set up user level security for your database?
View 2 Replies View RelatedI have 2 tables: Components and Lot Codes
In the Components table I have the following fields:
ModelType
Component
In the Lot Codes table I have the following fields:
Serial Number
Model
Component
LotCode Number
I want to restrict the data in the Lot Code Table so that when a model number is entered the only possible values for the Component field is one where ModelType and Component match in the Component Table.
This sounds confusing. . .basically selecting one item drills down the options for the next.
Can anyone help?
lets say i have three fields in my table..
all currency fields..
jobprice..
jobcarpark..
jobtotalfare..
is there a way at table level.. to set jobtotalfare as jobprice + jobcarpark because at the moment i am simply ensuring that in all the forms.. if the price or carpark is updated.. so is the total fare..
it would be much easier to do this at table level..
I have a small problem here
I was creating a human resource database for a large firm. The number of records ranges from 5000 to 6000. Initially everything went well. My designs and development were highly appreciated. But now because of just security my DB is being rejected. The problem aroused because of the security issues. I tried using the Logging On database as presented here in the Code section of this Site. But it was completely rejected by the authorities. They wanted something like following
1.The administrator has the power to give the user special privileges like mentioned in the User level security i.e making users like read-only, backup, data entry etc
2.The administrator has the power to block any user from opening any form whenever he likes.
When I presented them with the user level security as in Ms Access they were completely lost and they find it really difficult to use. Further more the names of the forms as I have used are starting with “frm” where as they want only the simple names of each form. If I start changing my form names I would complete mess up my DB
Please advice what should I do to make the user level security easy for them to use.
Or how can I develop my own security system in which user can use my above mentioned points.
I have implemented user level security on a database and it seems to work fine. The issue is that every other database on that computer seems to have inherited the permissions. I only want these permissions to refer to that one database.
What have I done wrong?
Thanks
Niall
Hi,
I have a question.
When we create a user-level security, we can do it of the Tools-Security-> user-level security.
However,
can we use VBA code to create user-level security? Yes/No.
I just curiously want to know.
Because I just know that VBA can update the user-level security.
Please let me know, thanks.