I have a set of command buttons on a form that open up a series of reports. The problem I have is that only certain users should have access to particular reports and I want to be able to put some kind of password protection in.
If anyone knows how to do this please let me know.
Thanks
HI ALL,
I have been working on some database protection techniques and have found floors in all of them.
Basically I have to protect a database not using the application password... which has a different password for each form. This means using form passwords ect... but all of them can be hacked by using the shift key on start-up does anyone know how to get around this as im stuck and could really do with another’s perspective.
Thanks in advance.
Hello guys
I was wondering if you can help?
Is it possible to password protect tables, forms and queries, how
Thanks a lot
I need to know if there is any way to password protect a single query. I currently have a database and there are several users that have access to run queries but I need to have some security as others are making modifications to queries that they shouldn't be.
View 2 Replies View RelatedHi,
I need some help creating a way for two different type of users to be redirected to different forms after entering a password.
I tried using the groups security in access but it's not good.
What I need the program to do is:
ask the user to enter a password. then if the password is correct and they are managers they will see the managers opening form ("form1") and if they are employees they will se a different opening form("form2") with less options and different reports.
thanks.
I have an old access 97 database that I can open with a user password, but cannot open as an administrator. I need to look at some development issues. My problem is that the vendor who wrote the database no longer exists to help me. Does anyone know how to strip off password so that I can examine this old database?
View 1 Replies View RelatedI have set up a front screen which has linked buttons to other forms.
When I open up some of the forms (using the buttons) I would like them to be password protected.
I know tihs is probably really easy, but I cant get it sussed!!
Any help would be appreciated.
thank you
Mojaveboy
I have a small tracking Access DB at work that someone put a password on. No one seems to know the password. I'm wondering if there is a file that stores the password so that I can remove it so I can access the DB.
Thanks for you help!
Password Protection for E-mailed Access Report
Sorry this is a bit long winded but here goes - we have a very simple Access 2002 DB of 60 – 100 client records. It’s updated weekly and a report is then sent to a distribution list. In the past it was printed and faxed. As all on the list have e-mail I set up a macro to e-mail the .mdb to an Outook Distribution List. It works wonderfully and is much easier and faster. However - a couple of weeks ago one of the users complained saying we must password protect the data. Our Exchange Server is not yet set up to use certificates and Ditital IDs so I worked out the only way I can think of to p/w protect the file. The data is exported as an RTF. Once the user is in Outlook she opens the attachment and runs a macro in Word which :-
Saves the RTF as a DOC file (uses the same name each time)
Saves the DOC file with password protection
However the user reports that often it seems to link to the previous weeks data unless she deletes the attached file and opens the TEMP internet files folder, finds the correct week and attaches that.
Can anyone think of an easier and more foolproof way of doing this – is there something in Access I have missed?
Thanks for any help or advice – Dika
I am trying to set password protection on a combobox where there are only a few people who I want to be able to select their name to provide authorisation. I found the below code on a website and modified it slightly for my table (tbl_Approval) that contains two fields; Approver and Password. I can see how the code is supposed to work however I keep getting a syntax error (missing operator) in query expression on line: Set rs = CurrentDb.OpenRecordset(sql).
Code:
Private Sub Approved_By_Enter()
Dim pwd As String
Dim rs As Object, rstable As Object, count As Integer, counter As_ Integer
Dim sql As String, recount As Integer
sql = "SELECT * " & "FROM [tbl_Approval] " & "WHERE [Approver]= " & Me.Approved_By
Set rs = CurrentDb.OpenRecordset(sql)
[Code]...
I would like to know if I can create a password protection on specific tables. Within my database, there are certain tables and/or reports to be view by a selective amount of personnel. Can I password protect just that view?
View 2 Replies View RelatedI have an Access 2010 form within my database in which I have a series of 8 tabs on a tab control. I am the only user who will have access to these tabs. I want to require a password in order to permit access to the tabs. The very first tab on the tab control works as a cover tab. There is no relevant information for anyone to view...only a graphic.
How to code the "on change" event of the tab control.
All -
Just as the title describes, I can't seem to find a solution to be able to link the front-end to the back-end tables through the common file dialog when the backend is an accdb file that is password encrypted.
See the example attached. Here it should work just fine per the Article at :
http://support.microsoft.com/kb/181076
I've found it works fine without a password encrypted back-end but not with a password encrypted back-end.
Anyone have any ideas? It would be nice to use this feature in Access as well as automating the relinking.
Thanks!
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?
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
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.
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.
I'm not good with access at all, i'm basically after removing all workgroup protection from a database file. I have full access to the file, admin passwords etc, i'm just having serious difficulty trying to find a tutorial or any information regarding how it can be removed!
View 2 Replies View RelatedHi,
I have been working on some database protection, in which I am trying stop my tables from being able to be imported from other databases.
Does anyone know where I should start or even if it is at all possible?
how can I protect table from being edited or deleted?:)
View 1 Replies View RelatedHi,
If i want to protect everything in the database how can i do that.
I dont want a password to open the database, and I only want users to be able to edit the records through my forms (without use of a password), but i dont want any1 being able to edit records manually, edit forms, or modules, however i do want them to be able to create and use macros and queries.
Thanks
Adam
I am looking for a script which would be able to give protection of SSN in tables and or view on forms when entering an SSN.....
does anyone out there have a script????
ie... 123-45-6789 would show in access table or forms
as xxx-xx-6789
Hello All,
I have created a management system for small home builders and contractors.
Typically these customers will have less than 25 users. So far I have installed it in a single customer’s site, but I want to expand.
I basically have two questions.
1. What is the best way to deliver this product without the end user needing Access?
2. How can I ensure they don’t make illegal copies and give to their friends or add user without purchasing more licenses?
Thank you all,
Joe
Hi all,
I've recently taken over a database that a collegue of mine was developing and he has disabled certain functions within the database which I can't enable. Specifically, he has disabled the ability to right click over anthing in design view so you can view the list of options available. Does anyone know how I can re-enable this feature?
Best Regards,
Aaron
Hi
I have been called in by a client who had a db app put together (not very well). The original developers simply are doing nothing and the client is in despair. They have asked me to see if I can both correct the original bugs and also develop the database on.
The history is one of many unanswered phone calls and emails with the occasional promise that never gets anywhere. We spoke to the developer today who said they couldn't give the access code and then spoke to the other part of the duo who said he didn't have the code but would see if he can talk it out of the developer.
The client is a charity and like doing things the right way so I think that they will have played fair with the developer but it hasn't been reciprocated.
In exploring what they have I have been blocked by a password when I try to get into the VBA.
Is there any way to crack into this?
It would be helpful to know so that if the promised password does not materialise (and they were not holding their breath) do I tell them it is a no-hoper, or might I be able to work through?
The only alternative would appear to be to start from scratch but I suspect that would be financially too painful for them.
There is nothing earth shattering in what it does - even if it worked properly - and it is a small FE/BE database. I have full access to the BE but need to get into the code behind forms and modules to see where it is going wrong.
Any help or pointers would be most appreciated. I recognise the ethical issues but also sympathise with a client who has been shafted.
Best wishes
hey,
looking for help with protecting form designs in a database.
We have some people here with enough knowledge to be dangerous.
I need to password protect the design of forms while allowing access to the tables in ACCESS and data entry.
Thanks,
SLH