Password Protected Button

Feb 13, 2005

Hi,

this is me again and I need your help!

How can I add a password to a button, i.e. whenever someone clicked on this button he has to enter a password in order to proceed to the form which the button opens?

any help will be very much appreciated!

Thanks and Regards!
CS.

View Replies


ADVERTISEMENT

Opening A Password Protected Excel File From A Command Button In Access

Dec 22, 2006

Hi All,
I have three excel files (ActualHires.xls, ActualPromotions.xls and
ActualSeparation.xls). These are password protected files (with the
same password). They are linked to an access database and whenever the
files are opened, one must supply the password and click the 'Enable
automatic refresh button.' What I was wondering was if this could be
done in access with a command button. I have pasted some code below
that I found but now I'm getting an error.
This is the code:

Dim BookNames As Variant
Dim B As Long


BookNames = Array("O:ExcelFilesActualHires.xls",
"O:ExcelFilesActualPromotions.xls",
"O:ExcelFilesActualSeparations.xls")


For B = LBound(BookNames) To UBound(BookNames)
WorkBooks.Open FileName:=BookNames(B), _
UpdateLinks:=3, Password:="*******"
WorkBooks(B).Close SaveChanges:=False
Next B


But when I click the button, I get this error:
Run-time error '9' Subscript out of range.


and this line is highlighted:
WorkBooks(B).Close SaveChanges:=False


Any help would be greatly appreciated.


Thanks.

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

Password Protected Form

Aug 17, 2006

Hi all

I want to use a password for just a form and a report not all the database
if any one have example please help

Baig

View 1 Replies View Related

Password Protected Form

Nov 8, 2006

Hello All,

I have found the following code to password protect my form, it works but I have one problem, the input txt box does not have the input mask set so the password can be seen on screen, here is the code I have:

Private Sub Maintenance_Button_Click()
Dim strPasswd

strPasswd = InputBox("Enter Password", "Restricted Form")

'Check to see if there is any entry made to input box, or if
'cancel button is pressed. If no entry made then exit sub.

If strPasswd = "" Or strPasswd = Empty Then
MsgBox "No Input Provided", vbInformation, "Required Data"
Exit Sub
End If

'If correct password is entered open Employees form
'If incorrect password entered give message and exit sub

If strPasswd = "ssd" Then
DoCmd.OpenForm "Maintenance", acNormal
DoCmd.Close acForm, "Menu", acSaveNo
Else
MsgBox "Sorry, you do not have access to this form", _
vbOKOnly, "Important Information"
Exit Sub
End If


End Sub


Can anyone advise on what vba cmd to use in the password string to enable the password input mask?

Regards

View 2 Replies View Related

Help Needed With Password Protected Buttons

Apr 12, 2006

Hi, I have a button on form A that opens form B, but i wud like to put a password on this button, so when you click it, you have to type in a password before form B opens.
I'm using access 2000.

Cheers
Alex

View 1 Replies View Related

Moving Password Protected Database

Dec 28, 2006

Hi Everyone,
I am attempting to move a password protected database to a different folder on our shared drive but I am not sure the steps that are needed to do so. The database is already split. Can someone please assist???

View 3 Replies View Related

Open A Password Protected Database

Jun 22, 2007

Hi,
I'm trying to convert a access database in to a sql server. My client hasn't got the exclusive access or doesn't have a username password for the access database. I'm trying to import the data in the access to sql server and when I try to open it it says
"
This error is usually associated with opening or converting a security enhanced Access 97 or earlier database. If you are not the owner of the database, you most likely will not have the necessary access rights to open or convert it.
"

Is there a way around this.

Cheers,
-Vije

View 2 Replies View Related

Back-end Db Password Protected FE Probs

Apr 2, 2008

Hi guys!
I have a front-end (FE) linked to a back-end (BE) db.
I have added a password to the BE, but the knock on effect is that the FE won't work now. Just says 'Invalid Password'.
I'm using MS Access 2002.

Any help would be appreciatted.

(The password is to prevent unwanted users from deleting data on the BE on the server)

View 1 Replies View Related

Adding A User In A Password Protected Database

Feb 8, 2007

I use a database that someone else set up and is no longer here. To get access to the database you need to enter a user id and password. I have a new user who has been getting into the database using an established user's id and password.

I went into the file and found the table with the users, their id's and passwords listed, and added the new person to the table, but I still get an invalid user message when trying to access the database with the new user's information.

I went through the Access Help and tried a couple things it said for adding users to a password protected database, but either I didn't do it right, or the way to add a user is different from what I am getting from Access Help.

Lastly, this database is different in that if I would add a report, it only shows up on my computer when I access the database, the report doesn't show up on anyone else's. That is odd to me, but it is how it works.

Thank you for any help you can give.

View 2 Replies View Related

Open Password Protected Access 2007 Db In ASP

Feb 11, 2008

Hi, I have been opening password protected access 2003 databases with ASP / ADO for years now. However now we have updated to office 2007 everything gone bottoms up.

I have an access 2007 database (newly made, not converted from 2003), and a fresh asp page. I've gotten the new connection string information for Access 2007 from the internet yet the page cannot open the database.

connection string being used:

sConnString="Provider=Microsoft.ace.OLEDB.12.0;Data Source=" & strPath & ";Jet OLEDB:Database PASSWORD= password"

When I try to open the page the error i get is - "Not a valid password" - 80040e4d. I'm 100% sure the password is correct, the driver is right (the server has office 2007 installed, and the new access driver from the M$ website). Every page i've seen on the internet says that the code I'm using is correct, yet asp still can't open it.

If i remove the password from the database it opens fine, so it's not a corrupt database, or bad path in the code.

If you can shed any light on my problem I would be eternally grateful - been working on it for hours now!

Many thanks
Ryan

View 10 Replies View Related

Modules & VBA :: Transferring A Form To Password Protected DB

Feb 10, 2014

I have a mdb file that does not have database or user level security, but it does have a VBA password.I want to transfer (overwrite) a new form to this database from another Access database. The form I'm exporting has VBA code. When I try using docmd.TransferDatabase I get an error. The error is:

"The TransferDatabase action was canceled."The line is:

DoCmd.TransferDatabase acExport, "Microsoft Access", txtCheckInFile, acForm, "SubformLineSummaryContractor", "SubformLineSummaryContractor", False, False

where txtCheckInFile is the location and mdb file name I'm trying to send the export.It might be because the form already exists. So, if I go into the database and delete form, and repeat the export I get the message:

"Microsoft protect this Visual Basic for Applications Project with a password. You must supply the password in the Visual Basic Editor before you can perform this operation."My question is it possible to transfer a form to a MDB that has a passworded VBA? I know the VBA password.If not, perhaps it is possible to remove the VBA password in the database (using VBA), make my export, and then add the password back in?

View 2 Replies View Related

Modules & VBA :: Map Drive On Server Which Is Password Protected

May 7, 2014

I need to map drive on server which is password protected..so i used this:

Code:
persistent = false
set objNetwork = WScript.CreateObject("WScript.Network")
objNetwork.MapNetworkDrive "driveletter:", "serversharename", persistent, "username", "password"

but I get an Error 424 'object required'
in this:
set objNetwork = WScript.CreateObject("WScript.Network")

some other method to map password protected drive

View 3 Replies View Related

General :: Deploying A Password Protected Backend

Sep 23, 2013

I have to do this and I believe there is VBA code to re-link tables when needed that can be found on the web. My client needs access to everything because he will move on to another developer after this, so what I thought I would do is send him a private file that has the password for the backend and then just write the ADO code needed in the app's front end to connect with the password.

View 2 Replies View Related

Batch Process To Open Password Protected Access Db

Jan 30, 2008

Hi All

I need to schedule the opening of a MS Access database which is password protected.

I think the best way to do this would be to use schedule a batch process to run, can anyone help with the script to create a batch proccess to only OPEN and CLOSE an MS Access database?

Thanks

View 1 Replies View Related

Forms :: Password Protected Form - Showing Asterisks

Jul 16, 2013

I have a password protected form that works fine. However, when you type in the password it can be seen on the screen. Is there a way I can change that so that when the password is typed in it can't be read (perhaps showing asterisks)?

This is what I'm using:

In ON CLICK event
Dim PassWord As String
PassWord = InputBox("Enter Password")
If PassWord = "MYPassword" Then
' Open Form
DoCmd.OpenForm "MYFormName"
DoCmd.GoToRecord , , acNewRec
Else
MsgBox ("You're not authorized")
End If

View 6 Replies View Related

Modules & VBA :: Copy Table To A Password Protected Database

Dec 11, 2013

I'm using the DoCmd.CopyObject method to copy a table from my front end db to my back end. My back end db is password protected and it keeps prompting me for the password. Can I somehow send the password in code so that the user is not prompted?

View 8 Replies View Related

Modules & VBA :: Detecting Excel File Is Password Protected

Apr 4, 2014

Any VBA code that would tell me whether an xlsb file is password protected?

View 5 Replies View Related

Forms :: Permit Only 50 Group Leaders To Input / Edit Data On Password Protected Forms

Jul 29, 2015

I am building a very comprehensive Membership Management Database with extremely useful facilities initiated by some 20 or 25 Queries..

The database includes 5 Tables which store data relevant to members, another which stores details of Interest Groups and a 3rd which stores which members are affiliated to which Group or Groups.

Currently the database is accessible only by a very limited number of persons and data can be entered/edited by only one person. The database, using Access 2010, is maintained on a desktop computer and synchronized to a copy on a Cloud.

My requirement is to permit some 50 Group Leaders to input/edit data on a Password protected Group Members Form such that that is the only element of the database that they can access. The Forms would have only 2 fields from which the user would select entries from drop down lists.

My query is ; is such a procedure feasible in principle and would I be correct in assuming that the user would require to have available a copy of Access.

View 7 Replies View Related

Relink Backend File Using VBA With Password Protected File

Nov 5, 2013

I have a code to relink a 2 backend files at start up. The problem is one of the files is password encrypted.

Code to input the password?

Dim dbsTemp As Database
Dim strMenu As String
Dim strInput As String
' Open a Microsoft Jet database to which you will link
' a table.
Set dbsTemp = CurrentDb

[Code] .....

This part is calling the password protected database

Code:
ConnectOutput dbsTemp, _
"Usernames", _
";DATABASE=C:UsersquicoDesktopWeight_estimate_software_Usernames.accdb", _
"Usernames"

View 2 Replies View Related

Password Protect A Button

Feb 3, 2005

Can someone point me in the right direction of how to protect a button using a password please

cheers

Andy

View 1 Replies View Related

Button With Password Not Working

May 17, 2005

I have a form with a text field and a command button. My code works for the password part but it is not checking for the 3 times and exit code. I'm not real up oon coding and not sure what Im missing Any help would be appreciated:

Private Sub cmdLogin_Click()

If txtPassword = "Test" Then
DoCmd.RunMacro "Mac_man_main"
Else: MsgBox ("Please Renter Correct Password"), vbOKOnly, "Error!", 0, 0
Exit Sub
End If

'If User Enters incorrect password 3 times database will shutdown

intLogonAttempts = intLogonAttempts + 1
If intLogonAttempts > 3 Then
MsgBox "You do not have access to this database. Please contact your system administrator.", vbCritical, "Restricted Access!"
Application.Quit
End If

End Sub

View 2 Replies View Related

Password Protect A Button

Feb 3, 2005

Can someone point me in the right direction of how to protect a button using a password please

cheers

Andy

View 7 Replies View Related

Password On A Command Button?

Feb 11, 2004

Hi, i have a slight problem that i could really do with some help on.
I have a form in which u can edit/add or delete details of a record. What i would like to do is when someone presse's the delete button i would like a box to pop up asking for a password to be entered before the record is deleted just to prevent certain records from being deleted.

Thanks,

Ben

View 6 Replies View Related

Password On Command Button

Aug 2, 2006

On a "delete record" command button I want to put a password prompt so when you press it, it will only allow you to delete the record if a password is entered.

How?

View 3 Replies View Related

Switchboard Needs A Password On One Button

Feb 7, 2007

I have created a database where my boss wants a password on the one button to limit access. Is this possible. The button actually opens the Database Window (no one else knows the bypass to open it F11)

Thank you

View 1 Replies View Related







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