We have a fairly basic contact db at work which we use for incoming enquiries. Users need to be able to make ammendments to one particular field "Comments" after they have spoke to or received a call from someone. What I want to do is protect all the other fields in the table so a user cannot change any data by accident but can still input data into the "Comments" field. Is there a simple means of protecting the other fields, leaving "Comments" avilable for edit???
I have got two questions i would like to ask y'all.
1. I have created a data input form that feeds directly into a table is there any way i can protect that table so it can only be viewed by me but the form will still be able to feed in it. Something like a password system would be excellent, i know you can hide the database window and stuff like that but its not to hard to get round.
2. What are the chances of me being able to convert my form into a web page? i know you can create pretty decent web pages with it as it is but i would just love to drag my form onto a web page (Very unlikely but worth a try).
Any help with either of the above will be greatly apreciated.
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.
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.
I have developed an application which I want to keep safe from being tampered with by user.s So once a .mdb database application has been developed what is the best way to then distribute the application to a client (customer who has paid for the application) so that the application can't then be tampered with ?
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.)
hi i need to prevent my records in my form from editing or deletion.that is after cheking for accuracy. what is the best way to do this.i want to protect a record upon cheking it .but at the same time want to know how to unprotect the record.
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.
:confused: is ther anyway to lock ms access files , so that people would not be able to modify then and only view them, would not get to vbs screen etc, and give a limited password that will expire in given ammount of time.
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)
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?
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.
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?
I wrote an MS Access database before joining a client. I allowed them to use it. I am now leaving the company and would like to protect my intellectual property. Ideally I would like to put an "expiry date" in the database so that after a specified date it no longer functions, or will only function if they purchase the database. Anyway I can do this?
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?
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.
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.
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...)
What's the best way to go about protecting an MS Access database online? Hoping to launch tomorrow, but no can do without protecting the DB first
Basically, I have a database containing some personal information and I need to block people from downloading it, while still allowing my ASP pages to read/write/modify its data.
Can anyone point me in the right direction here? Any relative links, methods, tutorials, etc, would be a fantastic.
I've looked into User-Level Security Passwords, but am not sure if there's a better way to achieve what i'm trying to do (i.e. setting up specific access rights to the folder in which the MDB file is contained).
Thanks to some of the threads here, I have managed to automate inputting form data from a record into bookmarks in a word document template (a letter). What I am trying to do is to lock the letter allowing modification only to the form fields in that template. If the original template is locked (allowing entry only in the fields), the data does not flow through. So I was trying to accomplish this through the "ProtectedForForms" property. However, it does not work. The letter gets locked before the information flows through. Here's the code I am trying to use (borrowed from one of the users here):
Private Sub cmd_letWarn_Click()
' Check for empty fields and unsaved record. If IsNull(occupant) Then MsgBox "Occupant Name cannot be empty" Me.occupant.SetFocus Exit Sub End If
If IsNull(propad_no) Then MsgBox "Building Number cannot be empty" Me.propad_no.SetFocus Exit Sub End If
If IsNull(prop_ZIP) Then MsgBox "ZIP Code cannot be empty" Me.prop_ZIP.SetFocus Exit Sub End If
If Me.Dirty Then If MsgBox("Record has not been saved. " & Chr(13) & _ "Do you want to save it?", vbInformation + vbOKCancel) = vbOK Then DoCmd.RunCommand acCmdSaveRecord Else Exit Sub End If End If
' Create a Word document from template. Dim WordApp As Word.Application Dim strTemplateLocation As String
' Specify location of template strTemplateLocation = "T:PlanningPlanningEnforcementLogsuppfiles emp warn.dot"
On Error Resume Next Set WordApp = GetObject(, "Word.Application") If Err.Number <> 0 Then Set WordApp = CreateObject("Word.Application") End If On Error GoTo ErrHandler
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.
