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 Replies
ADVERTISEMENT
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
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
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
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
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
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
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
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
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
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
Feb 2, 2008
Hi,
I have a database that has been created for a company - all of the queries they need to run and changes they need to make to DB data is done through a series of Forms. Is there a way I can make it so all they can do is access the Forms (so they can't right-click and edit the form or edit any code etc.)
Thanks!
View 3 Replies
View Related
Oct 11, 2005
Hi there,
I have built a Access solution for a music school, It was installed on 3 machines.
I'd like to protect my database from installing onto another machine without my permission.
I did install database as a mde file so they cannot see my codes. However, if they copy the database to another machine (esp. another machine in different school) they can use my software without my permission. How can I prevent this? If they copy the mde file into unauthorized machine, database should work as a demo version (such as limiting the number of records in tables to 10). How can I do this? What should I check, hd id, mainboard serial or what? Is there any ready solution (at least modifiable) for that kind of problem?
regards
View 14 Replies
View Related
Sep 12, 2013
So i want to protect the back end of a database but im limited to what I can do....I am unable to restrict members from accessing the file by username...I am unable to place it in a local area which is pass protected...I am also unable to encrypt the back end as the front end needs to be able to access it (and I dont know how to allow it to do that...)
View 2 Replies
View Related
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
Dec 27, 2013
I have a timesheet data base and I wanted to find a way to restrict employees from editing other employees timesheets only their own timesheet... .is it possible with access 2010?
View 4 Replies
View Related
Jan 3, 2006
Hi, I have the SQL query below where I am JOINing two tables for two different databases. Both databases are password protected.
Query from MS Access
SELECT T2.cl_ser_id AS Expr1, T2.cl_idno AS Expr2, T2.cl_name AS Expr3, T2.cl_surname AS Expr4, TL.SiteRef, TL.Date, TL.Time, FROM [db2.mdb].tablenames AS T2, [db1.mdb].TransactionLog AS TL
My problem is accessing the second database from the first one.
db2.mdb is password protected !
If I remove the password from the second database.. the query works perfectly. Although due to security reasons, both databases must be password prtected.
Thank you for your help.. as always :D
View 2 Replies
View Related
Mar 30, 2006
This is technically not about Access I suppose, it's about an application called Simply Accounting, which uses the Jet Database engine. Please bear with me, because the expertise for Simply seems to be mainly about Accounting and not the the tech side.
If your not familiar with Simply Accounting ( SA from now on in this post ), it keeps its data in an .SDB file, which I gather is a renamed .mdb and it's security information in an .SDW file. An .LDB file pops up when users open the database, and disappears when the database closes. Sound familiar?
I'm trying to gather some information on how this security system works, as I have only an acquaintance with databases.
Basically my problem is that I have a SA database with 2 users, both of whom can log in to the DB independently but not concurrently. The database resides on one of the users computers, and the other accesses it from the network.
Environment:
2XP Pro WS, MSOffice, MSWorks, Simply Accounting, Avast, AluriaAntispyware.Peer to Peer LAN.
Identical User Accounts and Passwords on both PC's, ie User1 has the same UID and PW on both computers as does User2.
The problem:
User1 on PC1 can open database in single user or muli-user mode. If User2 on PC2 attempts to login and open database while User1 is has it open, User2 get a bad username/password error.
However if User1 on PC1 logs off, User2 on PC2 can open the database (which resides on PC1 ) successfully.
This worked well on their previous LAN on their old gnarly slow spyware infested computers, however on the new computers it does not work. Inf act if I move a copy of the DB over the old computer, multiuser use works perfectly.
I'm thinking it has to do with the way tyhe password files work...something to do with SIDs maybe...like maybe if users are connecting concurrently, the fact they are presenting SIDS from 2 different machines is screwing things up?
Perhaps the database is comparing SID from WS1 with SID from WS2 when User2 on WS2 tries to connect, and seeing they are different thinks it's a different person?
Anyway, if you know something about this, please please let me know
Thanks
Len
e-pni
www.e-pni.com
View 1 Replies
View Related
Sep 10, 2006
hi pals
i am newbie to msaccess. i want to set password to msaccess database file.
how to do this?
View 1 Replies
View Related
Oct 9, 2007
I am having a problem with a database. On one particular computer, a user tries to save data into a current database. The database prompts the user for a password. No password is set on the database. From what I have gathered from searching the internet, it appears that the database would be corrupt, but not so fast. About 20 other people use the same database and have no problems entering data into it without getting a password prompt. Even the same user that is having problems can enter data into the database from another PC, it is only this one PC that it is prompting the user for a password. Has anyone else experienced this problem and what can I do to fix this issue without re-imaging the PC? Thanks.
View 3 Replies
View Related
Sep 6, 2005
Hi,
How can I hide the Database window with password protection?
For example, if someone attempts to access the Database Window, they would be promted to enter the password before they can see the tables and queries...
Thanks for your help
View 1 Replies
View Related
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
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
Jul 28, 2006
Hello,
I have a database with certain startup options for the end user. What I
would like is for the database to prompt for a password ONLY IF the shift key
is used to try and bypass the startup options, so that only an authorized
person with the password can see the background of the database. If I simply
set a database password from the Tools menu, it asks for that password with
the startup options as well, and I actually locked myself out of a database
that way! So there needs to be some kind of check for whether or not the user
attempted to bypass the startup options, and based on that, ask for a
password or not. I am not sure if I can do this through Access options
directly, or I will require some coding, but either method is fine.
Please help!
Thank you,
Kriti
View 4 Replies
View Related
Aug 26, 2014
I am trying to open a database with a password (I know the password) from another database however I cannot work out how to do it. I have been using this code to do this to open databases without passwords for a while.
I am using Access 2007.
Code:
Private Sub Command36_Click()
Const cstrClientFEPath = "G:Templates"
Const cstrFEFile = "db.accdb"
Dim intX As Integer 'Utility var
[Code] ....
View 3 Replies
View Related
Jul 11, 2014
I was exploring using User-level permissions on databases so I, the admin, can have full permissions to edit/change etc. the database and certain users can only add/edit data. But I inadvertently have now set Access to ask me for a password for any db I open. Even if it's my own personal one. Can I set up Access to only ask for login info on certain db's, not all. I know that 2010 did away with User and group level permissions but was able to add it back through customizing the ribbon and adding this feature back to it.
View 9 Replies
View Related
