Friday, June 23, 2017   
  Search  
 
Register  Login  
Projects » VB 6.0 » Login Project  
   Download Minimize  
     
 Print   
   Project Login Minimize  

Project Login  is a small sample application which shows how manage a database (Access 2002-2003) using ADO 2.5.


The purpose of this project is to provide support to less experienced developers in the design of data-oriented applications using a database. In practice it is a kind of 'template'
project that can be used as a basis to develop or expand their applications.
Especially focusing on the management of data concurrency which is a critical step of the multi-user environments.

I hope this project helpful.

The project can be downloaded and modified freely without any restrictions.
The author disclaims any and all liability.

Optimistic concurrency
To test for optimistic concurrency (multi-user on LAN) perform the following steps::
- Compile the project
- Start 2 sessions of the compiled program, taking care to connect:
- in the first session with: user1 / password1
- in the second session with: user2 / password2
- open the same record in both sessions
- edit and Save the data in the last session, opened with user2 (the second)
- now edit the data and save in the first session opened with user1.
A message will indicate that the changes isn't allowed because the data are already been changed by user2.
To be able to edit the data, please refresh the original data from the database (Refresh button).

Useful reference for multi-user applications:
Use optimistic concurrency
http://msdn.microsoft.com/en-US/en-en/library/aa0416cz(VS.80).aspx
How To Implement Multiuser Custom Counters in Jet 4.0 and ADO 2.5
http://support.microsoft.com/default.aspx?scid=kb;EN-US;240317

 

Screenshots

 

 

     
  
   Version 4 Minimize  

Project Login v.4 - last update 02/15/2015

the fourth version of a small sample application which shows how manage a database (Access 2002-2003) using ADO 2.5.

What's new in version 4.0

English translation
    All project translated on english language (objects and database included)
frmDataGrid
    Row selection sometime was not refreshed correctly
Export Excel
    The user can choose the name of the Excel file, and the name of the sheet.

 

     
  
   Versione 3 Maximize  
     
  
   Versione 2 Maximize  
     
  
   Why ADO 2.5? Minimize  

Some might wonder why I never used ADO 2.5, instead of version 2.8.

The only reason is that being a project dedicated to those who are not very experienced, will find more comfort if he can use the help of ADO that only works up to version 2.5 (in fact).

Obviously in a real project will be more appropriate to use the version 2.8.

     
 Print   
DotNetNuke® is copyright 2002-2017 by DotNetNuke Corporation