Seperate Password For One Table??

Mar 3, 2008

Hey all,
For securing a database, is it possible to set a certain password for users to view just one table? like i've lots of tables in my d.b that i plan to use a workgroup file for different users to view it, but there's one that i only want certain people to access...can this be done at all??

Cheers,
Sue.

View Replies


ADVERTISEMENT

Fields Generated From A Seperate Table?

Feb 24, 2005

Hello,

I'm making a table with a Yes/No choice many fields which represent subscriptions.

The problem is that the subscriptions available will need to be changed fairly often - will this mean the table and the form associated with it need to be redesigned?

If so, I don't know how to make fields that change depending on a different table.

If this can't be done, I'd be interested to find out how else I could go about this.

Thanks for any help you guys can offer.

View 2 Replies View Related

Recall - Search Seperate Table

Nov 17, 2004

I want to be able to find the last value entered into a table from a form that is not based on that table. How do I go about this?

What I am trying to do is produce a 'purchase order number system' that adds 1 onto the previous number, but this purchase order can be generated on many forms and for many reasons across the database. I do not want to use autonumber.

Cheers,
Recall.

View 1 Replies View Related

SQL SP To Update 2 Records Using A Value Found In A Completly Seperate Table

Nov 9, 2005

OK this may be a bit of a weird one.

Here are my tables:

Table: Relationship
PK: RelationshipID int (Indexed No Dup)
FK: ContactID int (Indexed No Dup)

Table: Contact
PK: ContactID int (Indexed No Dup)
FK: RelationshipID int (Indexed Dup Allowed)

I also have following Local vars:
@Contact1 int
@Contact2 int

How do I create an UPDATE statement that will read RelationshipID in Relationship where Relationship.ContactID=@Contact1 and use it as the value to update the Contact.RelationshipID for all records in Contact where Contact.ContactID = @Contact1 or @Contact2

Hope this makes sense?

Also please let me know if I should post this in the SQL area instead.

View 1 Replies View Related

Append Data From Unbound Combo Boxes To Seperate Table

Aug 4, 2007

I have a form setup that has 5 combo boxes where a user will select one item from each combo box. Each combo box is from a differant table. Once this is done I want to be able to append or update the results into a new table I created. My problem is I don't know how to submit the data from the combo boxes to the new table. Can anyone help me with this?

Thanks

View 11 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

Password Protect A Table?

Dec 2, 2004

hi,

Is it possible to password Protect a table in Access 97?

I need to limit who can actually go into the raw data table as even though it is hidden, a user can easily unhide if they knew how.

any ideas?

View 3 Replies View Related

Password Field In Table

Jun 29, 2006

Hi all,

Need help urgently!
Need to know how to make the password field in table alphanumeric?
should i set in form or table?

thanks alot~!!!

View 1 Replies View Related

MDE File - Set Password For Table?

Jul 25, 2012

I created file .mde

How I can set password for table????

View 1 Replies View Related

Password Issues With Non Protected Database Asking For Password

Nov 8, 2005

Hi,

Firstly thank you for your help, this should be a simple one I hope, but is cracking my head on the wall. Have searched and searched and can't find an answer.

I have an Access Db that is not password protected, but is asking for a password.
It opens on any other machine fine?

I think my version of Access is playing funny buggers with me, any suggestions?

I was trying to implement some security on this Db, which is why it happened I'm sure. I ran the security wizard, set-up two users and admin with passwords, I have the output file to "recreate" something too.

Issue is, I then copied this Db to another computer for use on there, it worked without a Password, so didn't need to worry about it, now I can't open any Db on my machine??

Your help on this obvious pointer would be great!

C

View 3 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

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

Seperate One Column Into Two

Oct 20, 2006

Hi,

I was wondering if there was a query to run that would seperate a field in a column into to.

The Current Field is Prec and the entries all are numeric numbers followed by a dash and another numeric number i.e.
9700064-0
7600049-0
Another 7 digits-one digit
I would like the first 7 in a column called prec1 and the one after the dash in a column called grp

Thanks in advance

View 2 Replies View Related

Password Encrypting Database Table

Aug 26, 2012

is Access not like Excel where I can just put a password on the database table to prevent people from editing it? Excel is very simple to do this. however, it seems that Access you will have to do VBA scripting to get this task done.

View 4 Replies View Related

2 Seperate Sub Forms On One Form

May 24, 2005

Is it possible to have 2 sepaerate sub forms, with different source objects on a single form. I thought it was, but every time I save the main overall form, the source object of the second subform changes to the source object of the first.

Can anyone shed any light on this?

View 3 Replies View Related

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 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 :: Changing The Password In The Table From A Form

May 9, 2013

I have a login button in which if the username has an empty password or the user is his/her first time to login, another form will appear which is the Set New Password. How can I change the password of that current user, my Set New Password Form has two fields which is 'txtSetPassword1' and 'txtSetPassword2' and an OK button.

The user must enter a new password and a verification password, if the 2 fields matched, the new password entered will change the password in the table. The table name is 'tbl_UsernamesQry'.

I have done it but the main problem is, it changes the other's users password not the current user.

Here is my code for the OK button of that form Set New Password:

Private Sub btnSetOk_Click()
If Me.txtSetPassword1.Value = Me.txtSetPassword2.Value Then
Me.txtSetPassword1.SetFocus

[Code].....

View 11 Replies View Related

Tables :: Encrypting - Decryption Password SQL Table

Mar 6, 2015

Just wondering what the best way is to Encrypt and decipher a field in SQL.

Basically i have a User table that has a Password. I want to make this encrypted so the password cannot be viewed.

What is the best way to achieve this?

View 7 Replies View Related

Forms :: Validate Password Field Against A Value In A Table?

Aug 7, 2015

Access 2007 / I'm creating a database form that has a combo box drop down pulling EmployeeName and a free text field to enter a password. I need the password entry validated against the password stored in a column on the same row as the Employee Name selected from the combo box when a button is clicked. . IF, that value is validated, I need the button click to also record a "time in" or "clock in" entry in a different table.how to validate the password.

View 3 Replies View Related

Seperate A Imported Field From Outlook

Apr 1, 2008

Hi

I have imported data from Outlook. The field I am interested in is the
'Subject' Field. This contains 3 effective segments,
1 employee name
2 description
3 job and sub job number

example of text in field is

M.Heywood Completed Job No.1708 8
N.Curry Completed Job No.1477

I wish to move the employee name into another field and also the job and sub
job number. I have tried the following Right() Function but it is not quite
working as I want

Right$([Subject],InStr([Subject],"Completed Job No.")-1)

For the records above the results are as follows

No.1708 8
No.1477

What I really want is to only get the text after the .

Any help please as this is my first time with this function

Thanks

Richard

View 1 Replies View Related

Link Two Seperate Database Tables

Mar 9, 2005

Is it possible to create a database and link this to a form and another database? What i want to do is link a network database with a local database on a client machine?

View 3 Replies View Related

Import A Csv File And Seperate Bad Data

Jun 15, 2005

I want to import a csv file and store the good data (which matches input masks, validation etc) into one table, and all the bad data which is rejected into another table.

I've read a bit about an import error table, and although I do get errors when importing the csv file, no such table is generated.

Many thanks

Cc

View 1 Replies View Related

Seperate Date And Time Fields

Jun 12, 2006

I'm working with a linked table that has a seperate field for the date, and a seperate field for the time (which show in the linked table as '11/30/1899 9:46:00 AM'). I need to calculate the time difference between 2 entries.

How can I merge the 2 fields into a combined date/time field for my calculations?

Thanks,

Sup

View 4 Replies View Related

SubForm Requery From Seperate Form

Aug 11, 2005

Hi. Having a bit of a problem getting a subform to requery/refresh after running a query from a seperate form. The seperate form is acting as a 'search form' and running query qSearch.

I've tried various things (requery the form, subform etc) but here is the code I'm currently using:

Private Sub RunqSearch_Click()
DoCmd.OpenForm "Papers"
Forms.Papers.RecordSource = "qSearch"
Forms.Papers!Authors.Form.RecordSource = "qSearch"
Forms.Papers!Authors.Form!AuthorName.ControlSource = "qSearch.AuthorName"
Forms.Papers!Authors.Form.Requery
Forms.Papers.Requery
DoCmd.Close acForm, Me.Name
End Sub

The main form is requerying fine, but the subform isn't. Any help would be appreciated. Thanks

View 4 Replies View Related

Seperate Text Boxes From Labels

Jun 8, 2006

I am learning access on my own using MS Press step by step manual and it tells me to hold down the shift key while selecting the text boxes that are next to the labels, but when I do the labels get selected also . how do I disconnect the labels from the text boxes in order to insert space between the labels and the text boxes as it intructs me to in the book. I am able to select the labels separately, but it will not allow the text to be selected separately.

View 1 Replies View Related







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