DB/Reporting :: Add Data-entry Capability To My App Using Password-protection User-access
Mar 8, 2009
I'm presently creating an application which uses Access2007 as the database. No problem there. But Since most use Excel for data-entry, i've created two tables in access linked to excel source file. Any change in excel will reflect in Access database and subsequently in my Application . Until now my application only reads the database and displays records in DataGridView. These records, i then export to excel along with other formatting for direct printing as a report as I have no idea how to make report. Now i want to add data-entry capability to my app using password-protection user-access. So i can directly add new record to source file. Also need to know if There's any way of eliminating Access from the picture entirely....
That code works to read the entry data and to recognise the correct data, and the incorrect. However, even if entry is correct, the error msgbox will appear (x times of how many records there are in file), despite being navigated to the menu. Anyway that the Else isn't triggered when data is correct. Also for it to appear just one instead of (x times of how many records there are in file.)
I am using the Mysql .NET connect and can connect to my database using my program. i want to be able to get a Users Password from the database using there user name
This is the query i want to use: "SELECT Password FROM staff WHERE Username = " & textbox1.text & " '". But i don't know how to run that query and to get it to store the Password as a variable
How do you get a textbox being using for password entry to display the black circle that you often see in web forms, on the iphone etc etc?
I can change the PasswordChar property to an asterisk no problem and even copying and pasting symbols inserted into Word seemed to work - just couldn't find a symbol that looked like a bullet point!
Can this actually be achieved for a standalone exe, or is it something unique to web forms? Surely copying and pasting symbols from Word isn't actually the answer?
I need to open a password protected Access database from VB and I'm trying to use the Process.Start method and have had no luck. I have tried this seversal different ways and can't seem to get it to work. Here is an example of my closes attempt:
I'm making a login screen but i couldnt find a way to make textboxes invicebel but useable so i used labels but now the password label doesnt show password protection is there anyway i can give the label ******* pasword protection?
i'm trying to create a program that enables a user log into the program using a username and password, first he/she must first create an account with some vital information incase the password is forgotten so it can be retrieved
I am making an program that stores most of my text files in it. So I need a secure password protection to protect my information's. I was told that MD5 will get the job done, so I used an MD5 protection to see if it'll be good. I gave the test program to a guy I know and he manage to get my password within a minute. (I am still a bit new to VB so which encryption to use...)
I am trying to figure out a way to implement password protection on documents that a program I am working on creates. They should remain with the document regardless of where it is copied to or sent.Here is a rough sequence of events:
1. Application Opens (no document loaded).
2. User opens document with extension registered to application.(could also be # 1 if they clicked on the document directly)
3. Application Security checks document for security and prompts if necessary.
4. If prompted, user enters password.
5. Application checks password.
6. If passed, document opens, otherwise user is notified of failure.
how to save data (for example some text that user type [as password etc]) and save that password on same location where is application. After saving I want to have also Load option so we can load saved data.
I would like to use only one user name and password to access two server. My sample codes as follow. re correct the codes
codes:
Imports System.Data Public Class AlertControl Public Shared Function LoginToAlert(ByVal alertUsername As String, ByVal alertPassword As String, ByVal testNumber As String) As String
I have two tables in one to many relationship in an access 2003 database.I am using vb6 and visual studio 2008.I want a data entry form (in grid view) for child table. I want to display & add, Update, delete child records accordingly with parent.
i.e. What I require is One combo box displaying a parent field and corresponding child entries will be shown in grid view. Data entry form for parent table may be on separate form.Is there a full sample source code for above mentioned theme.
i have been asked to make a form password entry but cant use a text box as it's opened from an MDI parent form so no main screen to speak of as such, my problem is at current the password works fine as shown below its basic stuff.
If InputBox("Please Enter Administration Password." _ , "Password Entry", "") = "trafficlight" Then 'Close current frmMDIChild and set the new form
[code]....
i want the input box to mask the characters been entered i know i could create my own input box and call that but is there a way to use the Default inputbox to mask the character input maybe watch the key presses saving input to a variable and displaying the asterix in its place? or am i overthinking it and there is a very easy solution like an inputbox that already masks input by a user.
I need to create a program that requires password entry. I was thinking of having a form that the user uses to set the password that only opens once (unless a button on the main form is clicked to reset the password.) once the password has been set, the form closes and another opens to enter the password and for each and every time the program is run. Another thing is that if the password has been entered wrong 3 times, the program gives a message box and closes on the ok button.
i dont know how to show the data in the ms access through visual basic, this is the form, if the details that are entered are correct, the password must popup i want it to show in the visual basic and here is my query, i dont know if this is correct, if you enter the "Question, and Qans" correctly, the password must popup
Dim retrieve = Me.LoginTableAdapter1.ForgotPasswordString(TextBox5.Text, TextBox6.Text) If retrieve Is Nothing Then MsgBox("Please the Correct Statement")
I'm working on a VB.Net Windows form that is supposed to manipulate an Access Database. I can Already read data from the database (placing them in a combobox) using the following:
Code: Private Sub Form2a_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load OpenFileDialog1.FileName = "" OpenFileDialog1.Title = "C# Corner Open File Dialog"
I'm trying to remember how to insert data in to a table. Here is my code
Code:
I get the error
Quote:
Number of query values and destination fields are not the same.
I also get some error about the Insert INTO part not being right somewhere. Am I doing this how you would do it, or how would you do something like this?
Using Access I created a few Data Access Pages. These web pages, once opened, work fine to manipulate data as intended, but they keep generating annoying warning messages.There are two messages that pop up every time the web page is accessed. Before the page opens the first message that pops up states: "This website uses a data provider that may be unsafe. If you trust the website, click OK, otherwise click cancel."After pressing OK on the first, the second message pops up and states:"This website is using your identity to access a data source. If you trust the website, click OK, otherwise click cancel."After pressing OK on both messages the page functionality works just fine.I've tried adding password protection to the database and even signing the project with a digital certificate, but I still get the warning messages. This would be fine except there are multiple end users for the access pages and I am trying to avoid the additional confusion this will create, especially since IT has restricted many of the users from editing the internet options.
See our Posting Guidelines for our policy on archived threads.I am confused as to where to place the following code snippet in my code. I put the function above my load event and the same exception still occurs:
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll
I'm using XP and access 2003 and visual studio 2005. I created a project and connect this project with database access file. and I created some textboxes and command button on the form. Is possible to modify and add a new record to the database without using the navigation toolbar by insert a code in the command button.
I am new convert from VB6 and needs some help developing a stand alone application in VB 2008 that needs access to stored data values.All applications I have developed so far have been for computers that have either SQL Express or Access installed locally on the computer. This has made development really easy since I could use ADO to access and query the data.
The application I am now developing will be installed on a computer that does not have any of the MS office applications and I do not want to install SQL Express on the computer. But I still would like to use an 'ADO type' functionality to access, query and modify the data stored in the system.I started looking into using XML, but I was unable to find much information on querying and modifying individual elements.
I am looking to create a simple password box that will ask the user for a username and pass, if the user is validated against the usernames and passwords in an .ini file the login box will close and launch a program also stated in the .ini file. I would also like to be able to launch different programs for different users.
the access data are not getting reflected on the DataGridView unless the form is reloaded again. I am acessing the MSAcess data for back end processing (SELECT,DELETE)using odbc connection and displayin on .NET form using DataGridVew
I have a problem with transfering data from MSSQL Server 2005 to Access.
I need to make a VBScript that can take out all data from one table in mssql and update one table in Access. The tables exist in both databases and looks the same, but there can be more data in the table from MSSQL Server so i need to update the table in Access with this data.
E.g. I have a table called: SMP_Alert in both database's. So i want to do something like this (dunno if that is possiable):
Set objConMSSQL = CreateObject("ADODB.Connection") conMSSQL = "Provider=SQLNCLI;Server=127.0.0.1SMP;Database=SMP;Uid=SA; Pwd=smp;" objConMSSQL.Open(conMSSQL)
[Code].....
Or do i need to create a recordset of the table (SMP_Alert) from MSSQL, and loop through it to transfer the data into the table in the Access database?
