ms-access-free-zone

Basic User Login Details Stored In Textfile

2011-06-25T02:53:00.000-07:00

Basic User Login Details Stored in text file.

This is a modified version of the earlier application.

This application is written to demonstrate how login details could be stored in external text file. In practice, this method should never be used. Login details stored in text file can easily be read by computer users and hence defeat the purpose of password protection.

The function "fnVerifyLoggerAgainstTextFile()" will read the correct username and password from the textfile "AuthorizedUser.txt" that must be stored in the same folder that contains this mdb application file.

Download Microsot Access application file:

http://www.mediafire.com/file/vm3o1ovrpr6jeea/basic-user-login-2.zip

Basic User Login

2011-06-24T07:16:00.000-07:00

Basic User Login

Checks user login details against hardcoded authorized user details.

______________________________________________________________

Source Code:

Option Compare Database

Private Sub cmCancel_Click()

'if user cancels, quit application

DoCmd.Quit

End Sub

Private Sub cmdOK_Click()

'check for valid input

'if textboxes are not empty, verify details

If Len(Me.txtUserName) > 0 And Len(Me.txtPassword) > 0 Then

'if verification is ok, greet user

'else, deny access

If fnVerifyLogger(Me.txtUserName, Me.txtPassword) = True Then

MsgBox "Authorised User Verified.", vbInformation, "Welcome"

Else

MsgBox "Login Failed.", vbCritical, "Login Failed"

End If

Else

'request further input

If Len(Me.txtUserName) > 0 And IsNull(Me.txtPassword) Then

MsgBox "Please enter password", vbCritical, "Login Error"

Else

If IsNull(Me.txtUserName) Then

MsgBox "Please enter username", vbCritical, "Login Error"

End If

End Sub

Private Function fnVerifyLogger(strInputUsername As String, strInputPassword As String) As Boolean

'hardcoded details are used just to try this form

'later can be replaced by table lookup which is a common practice

Dim strHardcodedUsername As String

Dim strHardcodedUserPassword As String

strHardcodedUsername = "user1"

strHardcodedUserPassword = "password1"

'initialize as false

fnVerifyLogger = False

If _

(strInputUsername = strHardcodedUsername) _

And _

(strInputPassword = strHardcodedUserPassword) _

Then

fnVerifyLogger = True

End If

End Function

Download Basic User Login Form:
http://www.mediafire.com/file/h12x3aokf22kam5/basic-user-login-1.mdb

Microsoft Jet Database Engine

2009-04-12T19:54:00.000-07:00

http://support.microsoft.com/kb/239114

Download MS Access 2007 Runtime

2009-04-12T19:38:00.000-07:00

http://www.microsoft.com/downloads/details.aspx?familyid=d9ae78d9-9dc6-4b38-9fa6-2c745a175aed

Download MS Access 2003 Runtime

2009-04-12T19:36:00.000-07:00

http://office.microsoft.com/en-us/access-help/obtain-and-deploy-the-access-2003-runtime-HA001120886.aspx

Download MS Access 2000 Runtime

2009-04-12T19:35:00.001-07:00

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c01725e4-926e-4c6a-b389-818ca4c27971&displaylang=en

Download MS Access 97 runtime

2009-04-12T19:30:00.000-07:00

http://www.microsoft.com/downloads/en/results.aspx?freetext=Microsoft+Access+97+Runtime&displaylang=en&stype=s_basic

MS Access from WikiPedia

2009-04-11T19:50:00.000-07:00

Microsoft Access is known for its ability to empower non-professional developers to create database applications on their own. Users can easily create tables, queries, forms and reports, and connect them together with macros. Advanced users can use VBA to write rich solutions with advanced data manipulation and user control.
The original concept of Access was for end users to be able to “access” data from any source. Access offers the ability to import and export data to many formats including Excel, Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC, etc. It also has the ability to link to data in its existing location and use it for viewing, querying, editing, and reporting. This allows the existing data to change and the Access platform to always use the latest data. It can even perform heterogeneous joins between data sets stored across different platforms. Access is often used by people downloading data from enterprise level databases for manipulation, analysis, and reporting locally.
A significant strength of Microsoft Access is its Jet Database format (MDB or ACCDB in Access 2007) which can contain the application and data in one file. This makes it very convenient to distribute the entire application to another user, who can run it in disconnected environments.
One of the benefits of Access from a programmer's perspective is its relative compatibility with SQL (structured query language) — queries can be viewed graphically or edited as SQL statements, and SQL statements can be used directly in Macros and VBA Modules to manipulate Access tables. Users can mix and use both VBA and "Macros" for programming forms and logic and offers object-oriented possibilities. VBA can also be included in queries.
Microsoft Access offers parameterized queries. These queries and Access tables can be referenced from other programs like VB6 and .NET through DAO or ADO. From Microsoft Access, VBA can reference parameterized stored procedures via ADO.
SQL Express or MSDE (Microsoft SQL Server Desktop Engine) 2000, a scaled down version of Microsoft SQL Server 2000, has been a free download for a decade and may be used with Access as an alternative to the Jet Database Engine.
Microsoft Access is a file server based database. Unlike client server RDBMS, Microsoft Access does not implement database triggers, stored procedures, or transaction logging.
In ADP files (supported in Access 2000 and later), the database-related features are geared more towards a client-server architecture with MSDE or Microsoft SQL Server serving as the back-end instead of using the Jet Engine. Thus, it supports the creation of nearly all objects in the underlying server (tables with constraints and triggers, views, stored procedures and UDF-s). However, only forms, reports, macros and modules are stored in the ADP file (the other objects are stored in the back-end database). This centralization of queries and tables in the database server offers a more restrictive environment which appeals to certain missions.
The advantage of an ADP is that it supports the direct creation and editing of SQL Server tables, views, and stored procedures. The disadvantage compared to the native Access database is the inability to keep temporary tables (the ADP cannot store local tables) or link to data from other sources. By definition, this eliminates the ability to query across different data sources. As a result of these limitations and improvements to the native Access database, Microsoft is recommending the use of linked tables in Access for getting to SQL Server data rather than ADPs.