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 RepliesHI 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 RelatedI 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,
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 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!
This is my first database. I'd like some suggestions on how I can improve my DB. I want it more secure too. I want one admin (me) and there will be 3 or 4 other users with different permissions. I also want a readers group so that people can see the DB and keep up with their appointments.
Please don't be too rash, this is my first DB =D I'm a n00b
Also, if you'd like to e-mail me my address is jon_ramsey36@yahoo.com.
Thanks =D I appreciate your input
Hi there,
I have converted an acc97 file to acc2003 (using acc2000 as an intermediate step).
The exit button on one of the forms sets a global variable value to a string, but this action LOCKS all subsequent forms for update.
The exact same code appears in the Acc97 version but does not create a locking problem.
Any ideas would be much appreciated.
Thanks you.
This is a follow up to a problem I had with a Subreport which I have now solved but would like additional information on the differences between 97 and 2000.
basically I ghad a subreport that worked in97 but gave Invalid Argument in 2000.
It appears that the linking field was too long and this caused the Invalid Argument.
The fileds were a concatonation of two fields. One Number and One Text Field. Yes they were a bit long in certain circumstances but for fairly good reasons. I believe these would be generated as Type Variant.
Does anybody know the differences in teh Variant Type between 97 and 2000. I have tried searching teh Help in 2000 but unable to find any info or indeed the correct phrase to search on.
len
I have an Image control on a form which I want to examine programatically. It seems there used to be a way of doing it using Point and PSet from info I have seen online. Is this contained in any of the libraries available under References in Access and if so which one...
View 7 Replies View RelatedI 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