Password Protecting A Table Or Restricting Access?

Aug 17, 2006

Hi,

Basically i have a single database with several tables in it. I want certain tables such as Ireland, UK, US etc to only be accessable by employees from those countries. Is this possible and if so, how?

I have looked at user/group permissions but can't figure out how to assign passwords to users etc.

Any help is much appreciated

Thanks
Scott

View Replies


ADVERTISEMENT

MS Access Password Protecting

Jan 30, 2008

HI,

I have a MS access 2003 database (in MDB format) which I use as a basic accounts system for our company (15 user). I have certain tables password protected depending on user using the old workgroup information file. This presents a problem as anyone can copy the database without linking the Information file and effectively get full admin access. I was looking to upgrade to Access 2007 but I gather that there is a different security engine and also a new file format (accdb file). I know that you can keep the same user security settings when upgrading to 2007 (while keerping the mdp file extension) but would be interested to know if I can improve security using 2007 while also being able to retain user-level access to certain tables like in access 2003? The major weakness in my system at the moment is anybody can copy the MDB file to another PC and access everyting...it seems too easy a system to crack. Do I need to completely reprogram my database using MySql on MSSql? Any advice would be appreciated?

Thanks in advance,

Shane

View 2 Replies View Related

Password Protecting Table Update From Combobox

Feb 7, 2006

I have a combobox on a form which is populated from a field to present a list for the user to choose from.

I have limit list set to 'N'

When the user types something in the combobox that is not in the field in the table then I want to prompt for a password. Effectively password protecting the update of the field from a combobox.

If the password is correct the text is written to the field in the table and if not then not.

Help ?

View 9 Replies View Related

Forms :: Password Protecting Field With Password?

Oct 24, 2014

i have found a code that brings up a box when tab or clicking in to a box for editing as below:-

Dim strPassword As String
If InputBox("Please enter the password:") <> strPassword Then
SomeOtherControl.SetFocus
TextBox1.Locked = True
End If

its just that need to add a password as well, i have tried to put this in between the <> but this does not work. i would like a message to say incorrect password as well if possable.

View 4 Replies View Related

Password Protecting A Form

Aug 30, 2005

Hi

I've got a button on a form that opens another form - nothing unusual, but it would be preferable if this second form was password protected i.e. the user clicks the button to open the form and is immediately prompted to enter a password. I've looked at user-level security wizards but that confused me even more.

The database is networked and is used by 25+ people by the way.

Any ideas?

Thanks for any help!

View 2 Replies View Related

Password Protecting Backend

Mar 2, 2007

I managed to password protect my backend (as the backend is on a server and anybody could access it) so i have it password protected so only i can gain access to the data.
Now, when i try and access the backend from the front end, the frontend prompts me that the password is invalid (indicating its trying to enter the backend using no password, thus an invalid password warning appears. And this means nobody can access the data from the frontend)

Is there a way to get round this password issue from the frontend? I.e. have the password for the backend, but when you access the frontend, it doesnt need the password for the backend (i have my own username/password system to log on to my database)

I know there are different user level securities you can use, but im not familiar with this. So if you have an idea about this, then im all ears but keep in mind I don’t really know how the security levels work in Access (nor do i have the time to learn it in depth or even find help other than here)

Many thanks for your help

David

View 4 Replies View Related

Password Protecting Tables

Jun 16, 2006

I have a set of tables, one of which contains sensitive information, which i need to password protect.

I've been through the User Lever Security Wizard a few times but i can't seem to find a security group account which will allow data to be input into a form but also to deny access to the afore mentioned table.

Can anyone help?

View 1 Replies View Related

Password Protecting Forms?

Jun 13, 2006

how can i password protect a form?

i want a have a button that on click will ask for the password. if the password is correct then proceed to open the for else tell them they are not authorized.

i know i would need an if statement but thats as far as i got..
can some one provide me with some sample code?

thanks

View 4 Replies View Related

Help With Password-protecting Database For Edits

Jun 6, 2007

Hello,

I designed and distributed a database client to a bunch of users. They have asked me to password-protect it so that anyone can open the database and view the forms, but a password is needed to actually make any updates. I am trying to do this, but everything in Tools--Security is making my head spin. I have actually already managed to somehow lock myself out of my own database, although I have another copy.

How do I set the Workgroup Administrator Files so that they apply to anyone? It wants to put a separate file on my C: drive, but I don't use this database, I distribute it to people who do. (The server is on a share drive, can I put the Workgroup file(s) there?)

What settings do I modify to require *anyone* to need a password to update? Or is that even possible? I don't really want to break up the users into different categories.

If anyone could walk me through this process I would really, really appreciate it.

View 6 Replies View Related

Password Protecting And Updating Problems

Nov 11, 2004

Hey Guys, I have a whole login system that I have created in asp. Now I am trying to make it more secure, and to also let the user modify settings or retrieve forgotten login information. I am getting the following errors:

changedpassword.asp - http://www.nuflowtech.com/logintesting/members.asp
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/logintesting/scripts/changedpassword.asp, line 31

memberscheck1.asp - http://www.nuflowtech.com/logintesting/members1.asp
Microsoft JET Database Engine error '80040e4d'
Not a valid password.
/logintesting/scripts/memberscheck1.asp, line 31

The pages are attached. If anyone could point me in the right direction as to what is wrong with the codes, I would apprecaite it. Thank you all for your help.

-JC

View 2 Replies View Related

Password Protecting A Form - Microsoft Tutorial Error

Jul 22, 2005

I was using this form tutorial to password protect my administrative tools. When I went to run it I received this:

"User defined type not defined" and the line Dim rs As DAO.Recordset was highlighted.

I have little experience with VB and I was wondering if someone here had any idea if it was their code that was wrong, or if it was something I did...

View 7 Replies View Related

Restricting Access.

Nov 18, 2006

is there a way to pw or restrict access for ppl to a table, form / control page?

View 1 Replies View Related

Restricting Access To Informatino

Oct 24, 2006

Hi

I have made up an Access database form for our Sickness Administrators to fill in when someone is off ill. I want the form to only show (on the drop down list of names) the people that that particular SA deals with - for example, Jill would enter sickness records for the Democratic, Legal & Personnel section. I am not sure how to go about this:

a) if I have one table with all of the employees names on it, is there a way of restricting Jill from seeing any names other than the ones that she deals with?

b) if I have separate tables for each section, would that be easier? and if so, do I just make a "switchboard" for them to click on the appropriate list?

Thanks!

Maria

View 8 Replies View Related

Restricting Access Via Comand Buttons

Apr 20, 2006

I have created a db and would like to apply the format of the attached zip file

I cannot seem to work out how it was done cutting and pasting the code is not working either if someone could take a look and give me a simple method of creating the desired solution i would be very greatful

The button to access the password will be called DCC Log In.

This will then allow the Command Button DCC to be Clicked (Previously Hidden as in the example)

This opens the DCC Form (already achieved by =openForms("DCC")

View 2 Replies View Related

Access 2010 - Restricting User Access

Oct 15, 2015

I have Access 2010 database.

I have a Reporting Dashboard form that inturn has many buttons to open up different reports and forms.

Now I have been asked to extend the access to a few other users with restricted access. The new users cannot see all the form and report buttons in the Reporting dashboard form.

How can i restrict this? They also need to be given separate logins and passwords. How I can accomplish this?

View 2 Replies View Related

Restricting Access To One Form For Individual Users?

May 12, 2012

If i split my Data base into a front and back end how would i restrict certain users only to input data on certain forms. Also how would i prevent them from accessing certain information.

View 1 Replies View Related

Protecting A Table.

Apr 28, 2005

Hello all,

I have got two questions i would like to ask y'all.

1. I have created a data input form that feeds directly into a table is there any way i can protect that table so it can only be viewed by me but the form will still be able to feed in it. Something like a password system would be excellent, i know you can hide the database window and stuff like that but its not to hard to get round.

2. What are the chances of me being able to convert my form into a web page? i know you can create pretty decent web pages with it as it is but i would just love to drag my form onto a web page (Very unlikely but worth a try).

Any help with either of the above will be greatly apreciated.

Cheers
Tim

View 2 Replies View Related

Protecting A Table

Jan 10, 2007

Hi There,

We have a fairly basic contact db at work which we use for incoming enquiries. Users need to be able to make ammendments to one particular field "Comments" after they have spoke to or received a call from someone. What I want to do is protect all the other fields in the table so a user cannot change any data by accident but can still input data into the "Comments" field. Is there a simple means of protecting the other fields, leaving "Comments" avilable for edit???

Regards
Keith:o

View 6 Replies View Related

Protecting A Table

Jan 15, 2007

Hi There,

Can anyone tell me a way of protecting the data stored within a table, so that users cannot inadvertently change or delete data from it???

Best Regards
Keith:(

View 5 Replies View Related

Protecting Access Files?

Feb 2, 2006

:confused: is ther anyway to lock ms access files , so that people would not be able to modify then and only view them, would not get to vbs screen etc, and give a limited password that will expire in given ammount of time.

View 1 Replies View Related

How To Crack Ms Access Password, I Have Set User Name And Password

Sep 12, 2006

hi pals

i have set username and password for ms access file.

unfortunately i have forget that password?

how to crack that username and passowrd?

is there any softwares available?

i can easily crack the database pasword? but how to crack username and password of ms access file.

View 1 Replies View Related

URGENT: Protecting Access Databases Online

Sep 20, 2006

Hi All,

What's the best way to go about protecting an MS Access database online? Hoping to launch tomorrow, but no can do without protecting the DB first

Basically, I have a database containing some personal information and I need to block people from downloading it, while still allowing my ASP pages to read/write/modify its data.

Can anyone point me in the right direction here? Any relative links, methods, tutorials, etc, would be a fantastic.

I've looked into User-Level Security Passwords, but am not sure if there's a better way to achieve what i'm trying to do (i.e. setting up specific access rights to the folder in which the MDB file is contained).

Thanks in advance...

View 4 Replies View Related

Protecting And Allowing Access To Specific Records

Apr 18, 2013

I just created a huge database using access 2010. How do i setup security level to allow access by groups to specific records?

View 14 Replies View Related

How To Access Ms-Access WorkGroup Tables To Change Database Login Password

Apr 13, 2007

Hi!
This is Kishore, working on VB Project which is using MS-Access95 as backend.
Now, i want to change the Database login Password.
Could anyone guide me in this context.

Regards,
Kishore

View 4 Replies View Related

Password Access

May 12, 2005

I obtained a login and user access from someone last year, (can't remember who it was,) and being relatively new to vba in access, have been unable to adapt it for use in access 97. Please can someone help?

The logon works great in access 2000, thanks whoever created it!

thanks
Blue-wyvern

View 2 Replies View Related

Not Prompted For Password When Relinking - 'Not A Valid Password Message'

Mar 29, 2007

I have recently split my database and added a password to the back end. I am now trying to re-link the tables as I have seen in other threads, but when I do this I am not prompted for the password I just get the message 'Not a valid password'

I must obviously be doing something wrong, can anyone help?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved