Results for "Category: Databases/ Data Access/ DAO/ ADO"

Generates DBMS Scripts (SQL Server Query Analyser) or VB6 Source Code from a database. Uses either ADO or DAO to connect to database depending on the output required. Query Analyser scripting is useful for migrating a Jet (Access) database to SQL Server. It migrates Tables, Indexes & Constraints (for Default Values etc). The VB6 code generator produces ADO or DAO Object based code to create the database in code or create Class Objects to encapsulate the Tables. Also creates Project & module to integrate all the build code. I intend to expand the langauges and DMBS it can script to. Hope it may be useful to some! Feedback welcome and votes always nice ;) - 23 Nov 05 New Upload

Hello To All This module demonstrates how to perform common operations with ADO. This bas is essential if you want to do any database access with ADO. It shows how to perform common task as well as complex task using ADO. The notes on top of each function is self explanatory. The important feature is that it shows comparison with DAO (the older database access technology)and instructs how to perform similar task in ADO and which parameter to use. Please Rate it. Thanks and Enjoy..

to make library more compact!

This sample shows how to secure Access database using ADOX and SIDs. In apps where database is created on-the-fly from code its only way to prevent your database from being modified.

This sample shows how create Excel file using ADOX. In database apps when ADO and ADOX is used it's simple way to create 'Excel reports'. Using ADOX is about 3 times faster than Excel Automation. If you find this code useful, please vote...

This tutorial will help, preventing more then one instance of any application, which contains this code in form_load event.

A simple application which shows how to call and manipulate Access Database records through ADO using Visual basic. Also, shows the proper GUI design for a transaction application. Please Rate :)....

This is a nice program for Browsing through the MS Access file i.e. *.mdb. It works quiet fast comparatively. This shows you the number of tables present in the selected Database. Further it will show the fields in the selected table.Theres also a provision for seeing the whole selected table in the grid. Its quiet a good thing for using & even for the users who are not well known with the usage of Access Databases & dealing with the uncertainity tables into it.

SQL Navigator is a very good Demonstration of Viewing the Tables, Views & Procedures present in SQL just with the help of some SQL in-built functions through ADO. It will show you the data in the table & even the text of the Procedure which you had made in SQL. Might be unknown to someone how to use the SQL functions through VB just by passing them into the recordsets. It can be used very well by making an application. It is very small easy to understand, fast & hey.. dont forget to rate my code...!!!

When you display data from a database to a DataGrid, you will see that DataGrid's columns width cannot adjust to the longest data in the field. I made one procedure that can fix the problem. This procedure will adjust DataGrids column width based on longest field in underlying source. Enjoy!!!

Confused how to make a database programming using ADO Code? This project shows you how to make a complete ADO Code database programming with: navigation (move first, move next, move previous, move last), add, update, delete, cancel, refresh, find first, find next, filter, unfilter, sort (ascending-descending), bookmark, and adjust datagrid's column. This project uses reference "Microsoft ActiveX Data Objects 2.0 Library" and database Microsoft Access 97. I made this project by using "VB Application Wizard" in Visual Basic's Project Type Dialog Box and I choose "ADO Code" and "Master-Detail" through "Data Access From". Then I modified the code by adding find, filter, sort, and bookmark procedure - each of them in one form. I made findfirst and findnext procedure because there is no findfirst and findnext in ADO. I added "Match whole word only" checkbox in Find form, also in filter procedure/form. I made "Bookmark" procedure, too. I didn't use ADO's bookmark property. The first time I posted this code, I used Indonesia language for comments in source code. Now I have translated them to English, include Label, Field Name, Help, etc. I hope this will help you to understand the code. Any comments and votes would be appreciated. Enjoy!!!

This project shows how we can print a very simple report to text file using RichTextBox control and to printer. The report contains simple information with quantity and sum of item per page, the sum of money per page, and total of sum of money in the end of report. User can select category to display the report. User also can change the number of record would be displayed in the screen/printer, and can change which printer will be used in combobox. The selected printer is the default installed printer in your computer. Including functions to adjust text-alignment in the report. This is very useful for you who want to print a simple report with many record to your screen and to your printer, without using the third party activex control. Any comments, feedback, and votes would be truly appriciated.

This project shows you how a user login to program and access menu based on his/her level. Program will display every possibility fails message whenever user failed try to login. The chances for login are only 3 times. After that, user must try again from begining. I also made a form to manage user account, that can be accessed only by user with level 'Admin'. Password field was encrypted in database. 'Admin' can manage all user accounts (add, edit, update, delete, change password, decrypt password, view user activity that saved in database, convert/transfer user activity data to log text file, and view that log text file). User can change his/her password. If user level is 'Operator' or 'Manager', he/she can only change his/her own password, but 'Admin', he can change all password user, and his too, of course. And I made menu to compact, repair, and backup database to manage your database performances. I use database Access97 password protected. I also made setting menu to change program setting (run program at startup - this will be occured if you had made an .exe file named 'LOGIN.exe', display screen saver if program idles in for a certain time, protect screen saver with user password, and don't show tips at startup. There is a 'Tips of Day' which display its data from text file. You can learn how to make a tips form and display the tips form or hide it at startup. The user activities that saved in database can be transfered to text file, and this log text file can be displayed from this program, too. So, user activities data can be transfered to text file, and you can delete the records from database. This will reduce your database file size. I made a screen saver form with analog clock. I used Thaha Husain's code to make the needle clock movement (just like a clock in your wall). Thanks to Husain for this code. Screen saver cannot be interrupted by 'Ctrl-Alt-Del', 'Alt-F4', 'Ctrl-Break', etc. Only active/current user can quit form screen saver. If user quit from this program, there will be an offers from program whether your computer would be shut down directly by program or not. Well, that's all I think. Hope it's very useful for you. Any comments, feedback, and votes would be appreciated. Thank you.

This is the first wizard I made and uploaded to PSC. I never saw the one like this on this site. So I made it. This program/wizard will help you and save a lot of your time to build an ADO Code Project. You can build your ADO Code Project by entering and selecting data/tables/fields based on Database or DSN or parameter you entered/selected to connect to your database. Everything is available in this wizard, included if the .mdb file was password protected. This you can't find in VB Data Form Wizard. So you don't have to build your project from beginning by adding controls on your forms, write the code, adding the components and references, etc. The wizard will automatically add those to your new project. You can also add the find, filter, sort, and bookmark procedure/form to this new project. I made this wizard because I often make ADO Code Database project in my office, and this is really really save a lot of my time. You can learn how to make wizard from this program. I got the template of this wizard from Visual Basic, and I modified as I want to, and I added a Help file that you can call from the wizard. As a matter of fact, this wizard is rather similiar to VB Data Form Wizard in Visual Basic, but I had modified the wizard by adding a lot of enhancements. Please download and prove it now. Any comments, feedback, and votes would be truly appreciated.

This is a payroll system, register new employees and gives them employee no, validates each & every entry. each month, operator can select the Employee ID can generate the Payslip. This is very perfect Payroll System, you should use this, learners will found it extremely useful.

This is a quiz administration programme. It was created with the military in mind (Navy) so to login you use an official number and a password.There are two groups of users, the administrators and the students. An adminstrator would have access to the questions database (being able to modify it or add new questions), he can also set the conditions for taking the test like number of questions type of questions and duration of test. Only an administrator can register or modify or delete other users. He also has access to all test scores and can prune the database. The questions are stored according to subjects and could be in form of True/False, Multiple Choice or Short Answer type. Each question can be associated with a picture. A student can either take a test of check his scores. All users can change there password anytime. Even though the application was written to suit the military it can easily be modified. Please leave you comments and views, as I am sure I still have a great deal to learn. I have indeed learnt alot from this great site and most of this code can be traced to this site. I am really gratefull to all members of PSC.

Using ADO & ADOX, convert between various database formats like Text, Access, Excel, dBASE, Paradox, HTML.

Using ADO & ADOX, convert between various database formats like Text, Access, Excel, dBASE, Paradox & HTML. This is a NEW VERSION of Any-to-Any Database converter. Please follow the link if you like to vote me / to get the original version http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=47434&lngWId=1

Simple Library System, I attach some codes from PSC that I downloaded.. Thank you!

Open a DB via DAO 3.5/6 with password protected! This code just for beginners like me ;) Not rated please, commented only. Thank you!