Password Protecting And Updating Problems

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 Replies


ADVERTISEMENT

Forms :: Password Protecting Field With Password?

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

Password Protecting A Form

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

Password Protecting Backend

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

MS Access Password Protecting

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

Password Protecting Tables

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

Password Protecting Forms?

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

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 6 Replies View Related

Password Protecting A Table Or Restricting Access?

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

Password Protecting Table Update From Combobox

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

Password Protecting A Form - Microsoft Tutorial Error

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

Not Prompted For Password When Relinking - 'Not A Valid Password Message'

Mar 29, 2007

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?

View 4 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

How To Crack Ms Access Password, I Have Set User Name And Password

Sep 12, 2006

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.

View 1 Replies View Related

Protecting A Table.

Apr 28, 2005

Hello all,

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.

Cheers
Tim

View 2 Replies View Related

Protecting A Table

Jan 10, 2007

Hi There,

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???

Regards
Keith:o

View 6 Replies View Related

Protecting An Application

Jun 30, 2007

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 ?

Cheers
Frank

View 4 Replies View Related

Protecting Database

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

Protecting A Table

Jan 15, 2007

Hi There,

Can anyone tell me a way of protecting the data stored within a table, so that users cannot inadvertently change or delete data from it???

Best Regards
Keith:(

View 5 Replies View Related

Protecting A Record

Oct 9, 2005

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.

View 9 Replies View Related

Protecting Access Files?

Feb 2, 2006

: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.

View 1 Replies View Related

Protecting Crucial Data

Aug 12, 2007

I have a single user DAO .MDE database application
where the calculations rely on data defined
by an external authority and it must not be altered.

To protect the data from accidental alteration,
it is my intention to imbed the data as text lines
in a module.

When the database is opened, a procedure empties
the data table and appends the contents of the text
in the module into the table.

There data consists of 62 records (rows) of 23 columns.
The data changes very rarely, and change would
involve simple text editing.

I am sure that others have come upon a similar
challenge, and my question is if there are other
methods to protect crucial data.

Thanks for any suggestions

View 2 Replies View Related

Protecting Intellectual Property

Feb 8, 2008

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?

View 14 Replies View Related

Protecting The Database - What Kind Of Solution?

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

General :: Protecting Back End Of Database

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

URGENT: Protecting Access Databases Online

Sep 20, 2006

Hi All,

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 in advance...

View 4 Replies View Related







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